Excel Tips
How to print (or not print) the ABC's and
123's on the worksheet?
With your spreadsheet open...
- Choose FILE and PAGE SETUP
- About halfway down under the print
heading, check the box next to ROW AND COLUMN HEADINGS.
- Now when you do a Print Preview you
should see the ABC's and 123's.
- Do the same to turn it off.
How can I change the font size, color, etc
for the whole page?
- To highlight the entire worksheet, click
the corner of the headings (directly above the 1 and to the left of the A)
- Then you can either change the font on
the formatting toolbar or ...
- Choose FORMAT
- Then CELLS
- Then select the FONT tab and you can make
the changes there.
How can I outlines cells or make the grid
print?
- Highlight the cell(s) you want
the lines around
- Select the arrow next to the
borders button on the formatting toolbar.
- You will see this menu drop
down with choices for the different types of lines you can put
around the cell.
|
 |
How can I uniformly change the width of
columns or height of cells?
- Highlight the columns (by clicking on the
letter headings and dragging) or rows (by clicking on the number headings
and dragging) that you want to change
- Then adjust the width or height of one
column or row by clicking and dragging on the line that separates the
headings.
- When you have finished adjusting that one
column or row, it will adjust all of the highlighted rows to the same size.
How can I adjust all columns to fit the
contents of the cells?
- Highlight the entire sheet (or just the
columns you want to adjust)
- Double-click on the line that separates
the column headings
- This will automatically adjust the
selected columns to fit the contents of that column.