LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

You can change the column headers to numbers (1, 2, 3,..., 255) or you can hide
them.

But you can't change them to something else.

But you could put your headers in Row 1 and
then select A2
and windows|freeze panes

so that row 1 is always visible.

And you can delete the whole worksheet by rightclicking on the worksheet tab and
choosing delete--you'll lose the data on that sheet, too.

You can hide all the worksheet tabs if you want.

Tools|Options|view tab
is where you'd hide the sheet tabs and row/column headers.

(Ctrl-pgup, ctrl-pgdn will swap between worksheets--nice if you've hidden the
tabs.)

Srini wrote:

Can we set the column names to what we want in an
Excel Spreadsheet rather than that default A, B, C... ??

Also can we either hide or delete Sheet names appearing
at the bottom of the sheet??

Thanks for the help
Srini


--

Dave Peterson
 
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
Excel column headers to a vertical list Steve F Excel Discussion (Misc queries) 0 April 27th 05 11:43 PM
Excel column headers to a vertical list Carole O Excel Discussion (Misc queries) 1 April 27th 05 11:01 PM
My Excel column headers have changed to numbers, how do I get bac. Monty Excel Discussion (Misc queries) 3 February 18th 05 03:33 PM
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 07:23 PM.

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"