Excel Fonts

C

Charlie 49ers

Is there a way to change the font and font size for the Row Numbers, and the
Column Letters?

Also, is there a way yo make the Row Numbers, and the Column Letters print?
 
S

Stan Scott

Charlie 49ers said:
Is there a way to change the font and font size for the Row Numbers, and the
Column Letters?
NO

Also, is there a way yo make the Row Numbers, and the Column Letters
print?

YES. Select File PageSetup and select the Sheet tab. There's a checkbox
available to print Row and Column Headings.

Stan Scott
NYC
 
A

Alan

Is there a way to change the font and font size for the Row Numbers, and
the Column Letters?

NO

In Excel 2002 (or at least the version of Excel in Office XP) there is,
Tools > Options > General, select font and size
Regards,
 
C

Charlie 49ers

Stan, thanks, and I found the "checkbox"! Hard to believe, with all the
stuff you can do in Excel, that you cannot change the font on the column and
row headings! Oh, well, maybe in Excel 2006. Thanks
 
G

Greg Wilson

Use the following dialog:

Sub Test()
Application.Dialogs(xlDialogFont).Show
End Sub

Regards,
Greg
 
D

Debra Dalgleish

To change the font and font size for row numbers and column letters --

Choose Format>Style
From the Style Name dropdown, choose Normal
Click the Modify button
Select the Font tab
Select a font and font size
Click OK, click OK
 
C

Charlie 49ers

Debra, thanks...that is exactly what I needed. I thought it was possible,
but could not find any instructions how to do it. I think a bunch of us
learned something. Thanks
 
Top