Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 20
Default How do I Change the Column Names (Re-Name A -

I want to Change the Column Headings from letters to actual names. How do I
do that?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,942
Default How do I Change the Column Names (Re-Name A -

hi
this can not be done. excel needs these to find/remember where everthing is
on the spreadsheet grid. you can change the letters to numbers but that is it.
on the 2003 menu bar...
toolsoptionsgeneral tab. check R1C1 reference style.
or you can get rid of the letters all togeather. on the 2003 menu bar....
toolsoptionsview tabuncheck row & column headers.
but they are still there, just not visible.
usually when someone want to wants to get rid of the column header letters,
they uncheck row & column headers then add their own headers and freeze panes.
place the curser on cell A2 then on the 2003 menu bar.....
windowfreeze panes.
if you want row numbers back, you can place the curser at cell B2 and freeze
panes. this will freeze column a and you and fill numbers down column A.

regards
FSt1

"Dallas" wrote:

I want to Change the Column Headings from letters to actual names. How do I
do that?

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,203
Default How do I Change the Column Names (Re-Name A -

All that FSt1 said, plus...
What most people do is use the top row(s) of the sheet for column
titles/headers and the same for the first column as titles for the rows. You
can even use File -- Page Setup -- [Sheet] tab and choose what rows to
repeat at the top of every printed sheet, and less often, what columns to
repeat on each sheet. In 2007 that is on the Page Layout Tab, using the
pull-down arrow at the lower right corner of the Page Setup group.

You can also use Window--Freeze Panes to keep rows/columns in view while
scrolling around on a worksheet. For Excel 2007 that's on the View tab,
within the Window group.

"Dallas" wrote:

I want to Change the Column Headings from letters to actual names. How do I
do that?

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
How do you change Excel column names from ABC to 123? joe92251 Excel Discussion (Misc queries) 4 May 9th 23 03:41 AM
Change Excel Column Headings from A,B etc to names? Sandy Mac New Users to Excel 2 May 22nd 08 06:34 PM
How do you change the column names e.g. A B C D E F dan Excel Discussion (Misc queries) 1 January 19th 06 08:58 PM
How do you change the column names in Excel? flutterfly Excel Discussion (Misc queries) 1 May 20th 05 09:56 PM
How do you change the column names,in Excel? flutterfly Charts and Charting in Excel 2 May 14th 05 12:34 PM


All times are GMT +1. The time now is 09:43 AM.

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"