Please remind me how to change the Font size, Width, Height of:

1) Sheet Column Headings at the top: A, B, C, ... (Font size & the row Height)

2) Sheet Row Labels on the left: 1, 2, 3, ... (Font size & the col. Width)

The option to do the desired changes must be under Tools::Options. Right ??

Thank you.

Goto the 'Tools' menu and select 'Options'.
Click the 'General' tab.
There should be a Standard font section. You can change the size there.
You'll need to exit Excel and come back in before the change takes effect.

HTH,
Paul


"monir" wrote in message
...
Please remind me how to change the Font size, Width, Height of:

1) Sheet Column Headings at the top: A, B, C, ... (Font size & the row
Height)

2) Sheet Row Labels on the left: 1, 2, 3, ... (Font size & the col. Width)

The option to do the desired changes must be under Tools::Options. Right
??

Thank you.

PCLIVE;

The Tools::Options::General::Standard font only affects the default font on
the sheet itself, not the font in the sheet column headings at the top (A, B,
C, ...) or the sheet row lables on the left (1, 2, 3, ...), and obviosly not
their height and width respectively.



"PCLIVE" wrote:

Goto the 'Tools' menu and select 'Options'.
Click the 'General' tab.
There should be a Standard font section. You can change the size there.
You'll need to exit Excel and come back in before the change takes effect.

HTH,
Paul


"monir" wrote in message
...
Please remind me how to change the Font size, Width, Height of:

1) Sheet Column Headings at the top: A, B, C, ... (Font size & the row
Height)

2) Sheet Row Labels on the left: 1, 2, 3, ... (Font size & the col. Width)

The option to do the desired changes must be under Tools::Options. Right
??

Thank you.

As for the Row and Column headers, this did work for me once I closed and
reopend Excel. And since the fonts of the headers increased, so did the
width and height of the columns and rows. However, the default text size
for the cells was also increased to this size. I don't know of any way to
change the default Row height and Column width.

Sorry,
Paul

"monir" wrote in message
...
PCLIVE;

The Tools::Options::General::Standard font only affects the default font
on
the sheet itself, not the font in the sheet column headings at the top (A,
B,
C, ...) or the sheet row lables on the left (1, 2, 3, ...), and obviosly
not
their height and width respectively.



"PCLIVE" wrote:

Goto the 'Tools' menu and select 'Options'.
Click the 'General' tab.
There should be a Standard font section. You can change the size there.
You'll need to exit Excel and come back in before the change takes
effect.

HTH,
Paul


"monir" wrote in message
...
Please remind me how to change the Font size, Width, Height of:

1) Sheet Column Headings at the top: A, B, C, ... (Font size & the row
Height)

2) Sheet Row Labels on the left: 1, 2, 3, ... (Font size & the col.
Width)

The option to do the desired changes must be under Tools::Options.
Right
??

Thank you.

Paul;

Let me rephrase my earlier statement to read: "The Tools::Options::General::
Standard font affects the default font & default row height & default column
width of the sheets in NEW workbooks, including the sheets row and column
headings. But it does not change anything in existing worksheets /
workbooks."

Here is the situation. My algorithm opens 4 workbooks (XL 2003, Windows
XP), and arranges them nicely on a single screen for easy reference and
manipulation of the data / results. The 4 displayed worksheets have the same
row heights, same column widths, and same standard font. But because 2 of
the worksheets have (mysteriously!) larger font in the column and row
headings, the sheets columns and rows don't align perfectly on the 4 windows.

A while ago, and unintentionally I might add, I came across the way to
change the sheet row and column headings (font, height, width, and even the
heading text!!). Unfortunately, I don't remember how !!.

Thanks for the efort.



"PCLIVE" wrote:

As for the Row and Column headers, this did work for me once I closed and
reopend Excel. And since the fonts of the headers increased, so did the
width and height of the columns and rows. However, the default text size
for the cells was also increased to this size. I don't know of any way to
change the default Row height and Column width.

Sorry,
Paul

"monir" wrote in message
...
PCLIVE;

The Tools::Options::General::Standard font only affects the default font
on
the sheet itself, not the font in the sheet column headings at the top (A,
B,
C, ...) or the sheet row lables on the left (1, 2, 3, ...), and obviosly
not
their height and width respectively.



"PCLIVE" wrote:

Goto the 'Tools' menu and select 'Options'.
Click the 'General' tab.
There should be a Standard font section. You can change the size there.
You'll need to exit Excel and come back in before the change takes
effect.

HTH,
Paul


"monir" wrote in message
...
Please remind me how to change the Font size, Width, Height of:

1) Sheet Column Headings at the top: A, B, C, ... (Font size & the row
Height)

2) Sheet Row Labels on the left: 1, 2, 3, ... (Font size & the col.
Width)

The option to do the desired changes must be under Tools::Options.
Right
??

Thank you.

Ok,

Not trying to annoy you or anything...

Click the top-left block of the worksheet (empty block in header bar between
"1" and "A").
Then right-click on the current worksheet tab and choose 'Select All
Sheets'.
Next, right-click anywhere in the selected area and select 'Format Cells'.
Select the 'Font' tab. You can change the font size for the current
workbook here.

This may not be exactly what you're looking for, but it may help you
remember how you did it before.

HTH,
Paul

"monir" wrote in message
...
Paul;

Let me rephrase my earlier statement to read: "The
Tools::Options::General::
Standard font affects the default font & default row height & default
column
width of the sheets in NEW workbooks, including the sheets row and column
headings. But it does not change anything in existing worksheets /
workbooks."

Here is the situation. My algorithm opens 4 workbooks (XL 2003, Windows
XP), and arranges them nicely on a single screen for easy reference and
manipulation of the data / results. The 4 displayed worksheets have the
same
row heights, same column widths, and same standard font. But because 2 of
the worksheets have (mysteriously!) larger font in the column and row
headings, the sheets columns and rows don't align perfectly on the 4
windows.

A while ago, and unintentionally I might add, I came across the way to
change the sheet row and column headings (font, height, width, and even
the
heading text!!). Unfortunately, I don't remember how !!.

Thanks for the efort.



"PCLIVE" wrote:

As for the Row and Column headers, this did work for me once I closed and
reopend Excel. And since the fonts of the headers increased, so did the
width and height of the columns and rows. However, the default text size
for the cells was also increased to this size. I don't know of any way
to
change the default Row height and Column width.

Sorry,
Paul

"monir" wrote in message
...
PCLIVE;

The Tools::Options::General::Standard font only affects the default
font
on
the sheet itself, not the font in the sheet column headings at the top
(A,
B,
C, ...) or the sheet row lables on the left (1, 2, 3, ...), and
obviosly
not
their height and width respectively.



"PCLIVE" wrote:

Goto the 'Tools' menu and select 'Options'.
Click the 'General' tab.
There should be a Standard font section. You can change the size
there.
You'll need to exit Excel and come back in before the change takes
effect.

HTH,
Paul


"monir" wrote in message
...
Please remind me how to change the Font size, Width, Height of:

1) Sheet Column Headings at the top: A, B, C, ... (Font size & the
row
Height)

2) Sheet Row Labels on the left: 1, 2, 3, ... (Font size & the col.
Width)

The option to do the desired changes must be under Tools::Options.
Right
??

Thank you.

I used a modified version of monir's procedure based on Gord's suggestion:

Doesn't matter what is selected, although it is helpful if it is different
from the font settings you intend to use so you can see the effect of the
undo.

Format - Style... - Modify - Font tab
Change to desired for column headings and row labels.
OK - OK
CTRL-Z (or Undo Style)

This undoes everything *except* the change to the column headings and row
labels.