|
Excel – Adjusting Column Widths/Row Heights
Make your spreadsheets cleaner looking and easier to read by adjusting the column width and row heights. Here are a few ways to make these adjustments.
Using your mouse to adjust columns or rows
- To change the width of columns, use your mouse to drag the boundary on the right side of the column heading until the column is the width you want.

- To change the height of rows, use your mouse to drag the boundary on the bottom of the row heading until the row is the height you need.
- To change multiple columns or rows – use your mouse to highlight the columns or rows in the heading area and then use your mouse to drag the boundary.
Set a column or row to a specific width or height
- Highlight the columns or rows in the heading area and choose Format, Column (or Row), Width (or Height) and type in the exact size you’d like in the box provided. Or with the columns/rows highlighted – use your right mouse button and choose Column Width or Row Height to enter the size desired.
Make your columns (or rows) fit exactly to the content (Autofit)
- Simply highlight the Column (or Row) choose Format, Column, and Autofit.
Change the default width for all columns or rows on a worksheet or workbook
- Click its sheet tab and go to the Format menu, point to Column (or Row), and then click Standard Width (or Height). In the Standard column width box, type a new measurement.
Bonus Tip: Viewing the width or height of your column or row
- Put your cursor at the boundary of the row or column and click your left mouse button once – a yellow text area will appear showing the size (such as “Width 8.43 (64 pixels)”).
What is a UV Coating?
UV coating is a clear liquid that is spread over digital prints and then cured instantly with ultraviolet light. It allows you to print on a variety of synthetic materials and produce design elements that make it hard to tell a digital run from a conventional run. UV coating creates a tough, waterproof finish that can be applied as a gloss or satin.
One of our clients uses the UV coating to protect shopping cart ads from the elements. Other clients have their sell sheets and postcards coated so they don’t get damaged during use and handling.
Our UV experts can work with you to create a quality piece that you can be proud of. Call us at 203-934-4275 to discuss your next project.
PowerPoint – Adding a Template to Your Slide Design Library
It’s not uncommon these days to receive a PowerPoint template that you are required to use for your presentations. But how do you get this file (with a file name of *.pot) into your Slide Design library so it’s easy to use each time you need to create a presentation?
Using the Design Layout Task Pane do the following: – Open a new blank slide set – Right click on the slide and choose Slide Design. This will bring up the Design Layout Task Pane – From there choose Browse (on the bottom of the pane) and locate the .pot file you want to use and hit Apply. – Once you’ve done this it will always appear in the Design Layout Task Pane.
Bonus Tip: To find out where your templates reside - choose File, Save As. Under Save As Type in the menu box, scroll down to find Design Template (*.pot). This will make the saved templates appear and will show you what folder these reside in (generally it’s under Documents/Setting, Application Data, Microsoft, Templates)
Fun Facts for April – April Month-Long Observances
April Is Autism Awareness Month, International Guitar Month, Keep America Beautiful Month, National Child Abuse Prevention Month, National Frog Month, National Garden Month, Humor Month, National Volunteer Month, National Mathematics Education Month, National Poetry Month, and Stress Awareness Month!
|