#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default rename column header

Hi All,

Is it possible to rename column or row headers in Excel?

I mean the Columns A, B, C, D... abd Rows 1, 2, ...

Many Thanks
M
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 348
Default rename column header

Simo wrote:
Hi All,

Is it possible to rename column or row headers in Excel?

I mean the Columns A, B, C, D... abd Rows 1, 2, ...

Many Thanks
M

You can rename the column headers to numbers.
You can also hide both headers and enter whatever you want in the first
row and the first column, then freeze the first row and first column so
that they will always appear on your worksheet.


Bill
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default rename column header

Not in the way you're probably thinking. You can goto ToolsOptionsView
tabWindow OptionsUncheck Row and column headers then you can use row 1 for
your own custom column headers and you can use column A for your own custom
row headers but any formulas (for all practical purposes) would still need
to reference the default column/row headers.

--
Biff
Microsoft Excel MVP


"Simo" wrote in message
...
Hi All,

Is it possible to rename column or row headers in Excel?

I mean the Columns A, B, C, D... abd Rows 1, 2, ...

Many Thanks
M



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Query - Rename Column Dan Excel Discussion (Misc queries) 0 November 26th 07 10:11 PM
MS Query Rename Column Dan Excel Discussion (Misc queries) 0 November 26th 07 10:04 PM
Rename columns header from Alphabet to Numeric Seagull Excel Discussion (Misc queries) 1 August 30th 06 05:02 PM
How to rename a column title in excel? atta New Users to Excel 5 May 23rd 06 04:12 AM
IsPossible to rename header ABCD row? rtf500 New Users to Excel 3 January 8th 06 12:24 PM


All times are GMT +1. The time now is 06:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"