How does one change the font in column and row header?

[noah4305]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Is there a way to change the font in the column and row headers? I am trying to change the font size in row header that has the numbers and column headers that have the letters. For example A / 3225, I would like to make it smaller to fit the numbers in the allotted space.

 

[CyberTaz]

No, the formatting of the default Column/Row headings cannot be modified.

I'm not sure what you're actually asking to do, though... The Column
Headings never contain more than 3 characters (i.e., XFD) & the Row Headings
never display more than 5 digits (i.e., 35749). Although you can change a
column's width to be narrow enough to prevent its heading from displaying
all 3 characters, the width of the row heading bar is automatically adjusted
based on its need to display 3/4/5 digits -- its width cannot be manually
adjusted. What exactly are you attempting to do that makes it seem necessary
to change the font size?

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[noah4305]

I have a file where the numbers are at 5 digits and it is not adjusting... is there a preference that I should look for?

No, the formatting of the default Column/Row headings cannot be modified.

 

[CyberTaz]

I'm not sure we're talking about the same thing You still haven't
described what it is that you are attempting to do. Please understand that
nobody here can see what you're seeing. We have nothing more to go on than
what you tell us, so fully descriptive explanations are important.

From the description in your first message I had the impression that you
were referring to the gray strip on the left side of each sheet which
contains the default numbering for each row ‹ the Row Headings. I've never
seen a sheet where the row number did not fully display.

It now sounds more like you are referring to cell content ‹ data in one or
more of the columns of the sheet. If that's the case see Excel Help on the
topic: Change column width or row height

Regards |:>)
Bob Jones
[MVP] Office:Mac