Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do i change row and column headers to my own text?

how?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default how do i change row and column headers to my own text?

You don't.

Workaround.

Enter titles in row1.

Select A2 and WindowFreeze Panes

ToolsOptionsView. Uncheck row and column headers.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 20:49:02 -0700, jordana456
wrote:

how?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default how do i change row and column headers to my own text?

For all intents and purposes, you can't.

You can choose to not display the current row and column headers any use
your own *BUT* you'd still have to refer to cells using the standard
headers.

ToolsOptionsViewRow & column headers

--
Biff
Microsoft Excel MVP


"jordana456" wrote in message
...
how?



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default how do i change row and column headers to my own text?

And if you want to enter row headers too, do so in column A, and select B2,
rather than A2, before freezing panes.
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You don't.

Workaround.

Enter titles in row1.

Select A2 and WindowFreeze Panes

ToolsOptionsView. Uncheck row and column headers.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 20:49:02 -0700, jordana456
wrote:

how?




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
In MS Excel, how do I change the column ref headers from numbers . Bruce Lindfield Excel Discussion (Misc queries) 2 July 31st 08 12:30 PM
Change Exel headers text. ? KalliMan Excel Worksheet Functions 2 January 4th 07 07:40 PM
How to: Change color of column / row headers and selected menus? Mark Excel Discussion (Misc queries) 7 September 28th 06 11:51 PM
How do I change the color of my row and column headers? David DiLallo Excel Discussion (Misc queries) 1 May 25th 05 01:11 AM
how can I change the a,b,c, column headers in excel to names espray Excel Discussion (Misc queries) 1 January 13th 05 02:01 AM


All times are GMT +1. The time now is 10:25 PM.

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

About Us

"It's about Microsoft Excel"