Excel 2002 how to change font for entire spreadsheet

[jbclem]

After replacing my video card, on my Win2000 computer, many fonts and font
sizes changed. In Excel 2002, the font designations seem to be the same
(Ariel 10), but visually the font size is larger so I can see less of a
particular spreadsheet without scrolling horizontally.

Since this is a large spreadsheet it would be had to select it all using the
cursor(and then change the font size). And I don't see a Select All
anywhere. Is there an easy way to change the font size for an entire
spreadsheet?

John

 

[Michael Bednarek]

After replacing my video card, on my Win2000 computer, many fonts and font
sizes changed. In Excel 2002, the font designations seem to be the same
(Ariel 10), but visually the font size is larger so I can see less of a
particular spreadsheet without scrolling horizontally.

Since this is a large spreadsheet it would be had to select it all using the
cursor(and then change the font size). And I don't see a Select All
anywhere. Is there an easy way to change the font size for an entire
spreadsheet?

I'm not familiar with Excel 2002, but in Excel 2003, I can change the
default font in Menu: Format / Style... / Modify... / Font

This works for those cells for which no other style previously had been
selected. If so, select the cell A1 (Ctrl+Home) and type Ctrl+Shift+End
to select all cells, then apply the modified style from step 1.

YMMV.

 

[norie]

John

You can select all the cells in a worksheet by clicking in the top
left of the worksheet where rows and columns intersect.

Then you could change the font as you would normally do, but I
wouldn't recommend that.

If you want to change the font for all worksheets and workbooks change
the Normal style, sort of like what Michael suggested.