Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I change the names of individual columns for my worksheet?
Hello Everyone:
I am can't remember how to change the names of the columns in the excel spreadsheet. I need them to have words in them instead of just the letters. Thanks in advance for your help(:) -- LWP |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I change the names of individual columns for my worksheet?
LWP
You can't change them. You can however use Windowfreeze Panes, to show columns to the right and rows above where the cursor is when you take the command. (e.g, if in B2, then column and row 1 will always be in view). In XL2007, if you have a table then as you scroll off the bottom of the sheet, the headers 'jump' into these labels, but that is restricted to 2007, in tables. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "Lyriqqz" wrote in message ... Hello Everyone: I am can't remember how to change the names of the columns in the excel spreadsheet. I need them to have words in them instead of just the letters. Thanks in advance for your help(:) -- LWP |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I change the names of individual columns for my workshe
hi
and just to add... if you don't want to see the default xl headers and row number, you can to to... on the menu bar.... toolsoptionsview tabuncheck column & row headers. you can't show one and not the other, it a all or nothing thing. but you can create a column of numbers in the A column(if needed) and freeze panes on B2 to show your headers and row number and not the default xl row number and column letters. just an after thought. regards FSt1 "Nick Hodge" wrote: LWP You can't change them. You can however use Windowfreeze Panes, to show columns to the right and rows above where the cursor is when you take the command. (e.g, if in B2, then column and row 1 will always be in view). In XL2007, if you have a table then as you scroll off the bottom of the sheet, the headers 'jump' into these labels, but that is restricted to 2007, in tables. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "Lyriqqz" wrote in message ... Hello Everyone: I am can't remember how to change the names of the columns in the excel spreadsheet. I need them to have words in them instead of just the letters. Thanks in advance for your help(:) -- LWP |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I change the names of individual columns for my worksheet?
See your other posting.
Please do not multi-post...........a waste of time and effort for those who are posting replies that duplicate what others have replied. Gord Dibben MS Excel MVP On Sun, 27 Jan 2008 07:49:01 -0800, Lyriqqz wrote: Hello Everyone: I am can't remember how to change the names of the columns in the excel spreadsheet. I need them to have words in them instead of just the letters. Thanks in advance for your help(:) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use Replace function to change worksheet names | Excel Discussion (Misc queries) | |||
How do I change the case from all caps to proper for names I have in columns E, F, G? | Excel Discussion (Misc queries) | |||
In Excel, how do I change worksheet headers (A,B) to names (Box)? | New Users to Excel | |||
How to change the individual row into columns | Excel Discussion (Misc queries) | |||
How do I change the names of the cells or columns from "A" to wha. | New Users to Excel |