ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Font (https://www.excelbanter.com/excel-discussion-misc-queries/163933-font.html)

juanpablo

Font
 
How can I change the font of the column headers?

Gary''s Student

Font
 
The format of Excel's column and row headers is controlled by the Normal
Style. To change it, pull-down:

Format Style... Normal Modify and then pick your font
--
Gary''s Student - gsnu200752


"juanpablo" wrote:

How can I change the font of the column headers?


Gord Dibben

Font
 
For all new workbooks go to ToolsOptionsGeneral and change the Standard Font.

Close and re-open Excel.

For each existing workbook go to FormatStyleNormalModify.

Note: this will also change font of row headers.


Gord Dibben MS Excel MVP


On Mon, 29 Oct 2007 08:54:01 -0700, juanpablo
wrote:

How can I change the font of the column headers?



juanpablo

Font
 
Excellent.

thanks.

"Gord Dibben" wrote:

For all new workbooks go to ToolsOptionsGeneral and change the Standard Font.

Close and re-open Excel.

For each existing workbook go to FormatStyleNormalModify.

Note: this will also change font of row headers.


Gord Dibben MS Excel MVP


On Mon, 29 Oct 2007 08:54:01 -0700, juanpablo
wrote:

How can I change the font of the column headers?




cpb

Font
 
Gord Dibben,
Your instructions changed my entire WB. All I want to change are the
column/row headings, e.a., A B C 1 2 3, etc. Thank you.
cpb

"Gord Dibben" wrote:

For all new workbooks go to ToolsOptionsGeneral and change the Standard Font.

Close and re-open Excel.

For each existing workbook go to FormatStyleNormalModify.

Note: this will also change font of row headers.


Gord Dibben MS Excel MVP


On Mon, 29 Oct 2007 08:54:01 -0700, juanpablo
wrote:

How can I change the font of the column headers?




Gord Dibben

Font
 
I gave two sets of instructions.

Which one did you use?

Whichever.............................

CTRL + a to select all cells.

FormatCellsFont. Select what you want.

The row and column headers will remain as your first change.


Gord

On Wed, 4 Jun 2008 16:15:05 -0700, cpb wrote:

Gord Dibben,
Your instructions changed my entire WB. All I want to change are the
column/row headings, e.a., A B C 1 2 3, etc. Thank you.
cpb

"Gord Dibben" wrote:

For all new workbooks go to ToolsOptionsGeneral and change the Standard Font.

Close and re-open Excel.

For each existing workbook go to FormatStyleNormalModify.

Note: this will also change font of row headers.


Gord Dibben MS Excel MVP


On Mon, 29 Oct 2007 08:54:01 -0700, juanpablo
wrote:

How can I change the font of the column headers?






All times are GMT +1. The time now is 03:58 PM.

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