ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Format (https://www.excelbanter.com/excel-discussion-misc-queries/119271-excel-format.html)

Shukor Talib

Excel Format
 
How to change or format the font or font size of row number header & column
letter header in Excel

Allllen

Excel Format
 
Tools Options General Standard Font.
Then restart excel.
--
Allllen


"Shukor Talib" wrote:

How to change or format the font or font size of row number header & column
letter header in Excel


Shukor Talib

Excel Format
 
I am not asking how to change the cell font or font size.
It is the Row Number Header & Column Letter Header that I am interested to
change.
It is in the grey shade on the left (Row Number Header) and top (Column
Letter Header) I am referring to of the Excel file.

"Allllen" wrote:

Tools Options General Standard Font.
Then restart excel.
--
Allllen


"Shukor Talib" wrote:

How to change or format the font or font size of row number header & column
letter header in Excel


Mike Rogers

Excel Format
 
Shukor Talib


Format / Stlye / Normal / Modify / Font , select your changes and ok out

Does this help you?

Mike Rogers

"Shukor Talib" wrote:

I am not asking how to change the cell font or font size.
It is the Row Number Header & Column Letter Header that I am interested to
change.
It is in the grey shade on the left (Row Number Header) and top (Column
Letter Header) I am referring to of the Excel file.

"Allllen" wrote:

Tools Options General Standard Font.
Then restart excel.
--
Allllen


"Shukor Talib" wrote:

How to change or format the font or font size of row number header & column
letter header in Excel


Gord Dibben

Excel Format
 
Apparently you never tried the suggestion.


Gord Dibben MS Excel MVP

On Fri, 17 Nov 2006 10:08:01 -0800, Shukor Talib
wrote:

I am not asking how to change the cell font or font size.
It is the Row Number Header & Column Letter Header that I am interested to
change.
It is in the grey shade on the left (Row Number Header) and top (Column
Letter Header) I am referring to of the Excel file.

"Allllen" wrote:

Tools Options General Standard Font.
Then restart excel.
--
Allllen


"Shukor Talib" wrote:

How to change or format the font or font size of row number header & column
letter header in Excel



Mike Rogers

Excel Format
 
Gord Dibben

Are you trying to say it does not work? I did it before I posted, then went
back and did it again making sure I did not miss post something. Works fine
for me!!!!
Maybe a different version it does not. xl2000

Mike Rogers

"Gord Dibben" wrote:

Apparently you never tried the suggestion.


Gord Dibben MS Excel MVP

On Fri, 17 Nov 2006 10:08:01 -0800, Shukor Talib
wrote:

I am not asking how to change the cell font or font size.
It is the Row Number Header & Column Letter Header that I am interested to
change.
It is in the grey shade on the left (Row Number Header) and top (Column
Letter Header) I am referring to of the Excel file.

"Allllen" wrote:

Tools Options General Standard Font.
Then restart excel.
--
Allllen


"Shukor Talib" wrote:

How to change or format the font or font size of row number header & column
letter header in Excel




Mike Rogers

Excel Format
 
Gord Dibben

I found this post on 4/19/05 5:50 PM PST, and this is where I learned about
changing these fonts. What has changed?

"Monir

Have you tried FormatStyleNormalModify.

Change the Font size there for current workbook.

Will affect column and row headers as well as cell fonts(which can be changed
back to what they were).


Gord Dibben Excel MVP"

Mike Rogers


"Gord Dibben" wrote:

Apparently you never tried the suggestion.


Gord Dibben MS Excel MVP

On Fri, 17 Nov 2006 10:08:01 -0800, Shukor Talib
wrote:

I am not asking how to change the cell font or font size.
It is the Row Number Header & Column Letter Header that I am interested to
change.
It is in the grey shade on the left (Row Number Header) and top (Column
Letter Header) I am referring to of the Excel file.

"Allllen" wrote:

Tools Options General Standard Font.
Then restart excel.
--
Allllen


"Shukor Talib" wrote:

How to change or format the font or font size of row number header & column
letter header in Excel




Gord Dibben

Excel Format
 
Please re-read.

I am stating it does work, but OP must not have tried it or he would have seen
Alllen's suggestion was correct.


Gord

On Fri, 17 Nov 2006 13:31:02 -0800, Mike Rogers
wrote:

Gord Dibben

Are you trying to say it does not work? I did it before I posted, then went
back and did it again making sure I did not miss post something. Works fine
for me!!!!
Maybe a different version it does not. xl2000

Mike Rogers

"Gord Dibben" wrote:

Apparently you never tried the suggestion.


Gord Dibben MS Excel MVP

On Fri, 17 Nov 2006 10:08:01 -0800, Shukor Talib
wrote:

I am not asking how to change the cell font or font size.
It is the Row Number Header & Column Letter Header that I am interested to
change.
It is in the grey shade on the left (Row Number Header) and top (Column
Letter Header) I am referring to of the Excel file.

"Allllen" wrote:

Tools Options General Standard Font.
Then restart excel.
--
Allllen


"Shukor Talib" wrote:

How to change or format the font or font size of row number header & column
letter header in Excel




Gord Dibben MS Excel MVP

Mike Rogers

Excel Format
 
Gord Dibben

Gord..............Most humble apologies..... I did misundeerstand....

Mike Rogers

"Gord Dibben" wrote:

Please re-read.

I am stating it does work, but OP must not have tried it or he would have seen
Alllen's suggestion was correct.


Gord

On Fri, 17 Nov 2006 13:31:02 -0800, Mike Rogers
wrote:

Gord Dibben

Are you trying to say it does not work? I did it before I posted, then went
back and did it again making sure I did not miss post something. Works fine
for me!!!!
Maybe a different version it does not. xl2000

Mike Rogers

"Gord Dibben" wrote:

Apparently you never tried the suggestion.


Gord Dibben MS Excel MVP

On Fri, 17 Nov 2006 10:08:01 -0800, Shukor Talib
wrote:

I am not asking how to change the cell font or font size.
It is the Row Number Header & Column Letter Header that I am interested to
change.
It is in the grey shade on the left (Row Number Header) and top (Column
Letter Header) I am referring to of the Excel file.

"Allllen" wrote:

Tools Options General Standard Font.
Then restart excel.
--
Allllen


"Shukor Talib" wrote:

How to change or format the font or font size of row number header & column
letter header in Excel



Gord Dibben MS Excel MVP


Gord Dibben

Excel Format
 
No problem.

With my recent history, not a bad idea to question my posts at times.

Keeps me honest......sort of<g


Gord Dibben MS Excel MVP

On Fri, 17 Nov 2006 14:25:02 -0800, Mike Rogers
wrote:

Gord Dibben

Gord..............Most humble apologies..... I did misundeerstand....

Mike Rogers

"Gord Dibben" wrote:

Please re-read.

I am stating it does work, but OP must not have tried it or he would have seen
Alllen's suggestion was correct.


Gord

On Fri, 17 Nov 2006 13:31:02 -0800, Mike Rogers
wrote:

Gord Dibben

Are you trying to say it does not work? I did it before I posted, then went
back and did it again making sure I did not miss post something. Works fine
for me!!!!
Maybe a different version it does not. xl2000

Mike Rogers

"Gord Dibben" wrote:

Apparently you never tried the suggestion.


Gord Dibben MS Excel MVP

On Fri, 17 Nov 2006 10:08:01 -0800, Shukor Talib
wrote:

I am not asking how to change the cell font or font size.
It is the Row Number Header & Column Letter Header that I am interested to
change.
It is in the grey shade on the left (Row Number Header) and top (Column
Letter Header) I am referring to of the Excel file.

"Allllen" wrote:

Tools Options General Standard Font.
Then restart excel.
--
Allllen


"Shukor Talib" wrote:

How to change or format the font or font size of row number header & column
letter header in Excel



Gord Dibben MS Excel MVP



Shukor Talib

Excel Format
 
Hi Mike, it works...thanks....

"Mike Rogers" wrote:

Shukor Talib


Format / Stlye / Normal / Modify / Font , select your changes and ok out

Does this help you?

Mike Rogers

"Shukor Talib" wrote:

I am not asking how to change the cell font or font size.
It is the Row Number Header & Column Letter Header that I am interested to
change.
It is in the grey shade on the left (Row Number Header) and top (Column
Letter Header) I am referring to of the Excel file.

"Allllen" wrote:

Tools Options General Standard Font.
Then restart excel.
--
Allllen


"Shukor Talib" wrote:

How to change or format the font or font size of row number header & column
letter header in Excel


Shukor Talib

Excel Format
 
Aleen suggestion did not work.

"Gord Dibben" wrote:

Apparently you never tried the suggestion.


Gord Dibben MS Excel MVP

On Fri, 17 Nov 2006 10:08:01 -0800, Shukor Talib
wrote:

I am not asking how to change the cell font or font size.
It is the Row Number Header & Column Letter Header that I am interested to
change.
It is in the grey shade on the left (Row Number Header) and top (Column
Letter Header) I am referring to of the Excel file.

"Allllen" wrote:

Tools Options General Standard Font.
Then restart excel.
--
Allllen


"Shukor Talib" wrote:

How to change or format the font or font size of row number header & column
letter header in Excel




Gord Dibben

Excel Format
 
I find that very strange.

But maybe this will help............

To clarify, after following Alllen's suggestion all new workbooks will have the
altered row and column header fonts.

Existing workbooks will have to be changed via the FormatStyle method.


Gord


On Fri, 17 Nov 2006 18:53:01 -0800, Shukor Talib
wrote:

Aleen suggestion did not work.

"Gord Dibben" wrote:

Apparently you never tried the suggestion.


Gord Dibben MS Excel MVP

On Fri, 17 Nov 2006 10:08:01 -0800, Shukor Talib
wrote:

I am not asking how to change the cell font or font size.
It is the Row Number Header & Column Letter Header that I am interested to
change.
It is in the grey shade on the left (Row Number Header) and top (Column
Letter Header) I am referring to of the Excel file.

"Allllen" wrote:

Tools Options General Standard Font.
Then restart excel.
--
Allllen


"Shukor Talib" wrote:

How to change or format the font or font size of row number header & column
letter header in Excel




Gord Dibben MS Excel MVP


All times are GMT +1. The time now is 08:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com