Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing A,B,C column names to other names
I want to rename the columns instead of the A, B, C that is provided because
if I don't and I want to make a numbered list of something, the list will always be off by 1 because the 1 spot it taken up by the column name. Is there anyway to remove the A, B, C and put in my own column names? Thank you. Lisa H. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing A,B,C column names to other names
No, you can remove the built in headers (toolsoptionsview) and use the
first row as a header row but it will not be the same. -- Regards, Peo Sjoblom "Lisa H" <Lisa wrote in message ... I want to rename the columns instead of the A, B, C that is provided because if I don't and I want to make a numbered list of something, the list will always be off by 1 because the 1 spot it taken up by the column name. Is there anyway to remove the A, B, C and put in my own column names? Thank you. Lisa H. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing A,B,C column names to other names
no
but you can make your numbered list be in column A with Row()-1 "Lisa H" wrote: I want to rename the columns instead of the A, B, C that is provided because if I don't and I want to make a numbered list of something, the list will always be off by 1 because the 1 spot it taken up by the column name. Is there anyway to remove the A, B, C and put in my own column names? Thank you. Lisa H. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing A,B,C column names to other names
You can't. It's impossible to start with row 0 or something like that.
-- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Lisa H" wrote: I want to rename the columns instead of the A, B, C that is provided because if I don't and I want to make a numbered list of something, the list will always be off by 1 because the 1 spot it taken up by the column name. Is there anyway to remove the A, B, C and put in my own column names? Thank you. Lisa H. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing A,B,C column names to other names
You can remove (not show) row & column headers (it's both or nothing) but the
first (top left) cell is still A1 so I don't understand your statement that "the list will be off by 1" ..from where? Tools=Options=View ... uncheck 'Row & Column Headers' "Lisa H" wrote: I want to rename the columns instead of the A, B, C that is provided because if I don't and I want to make a numbered list of something, the list will always be off by 1 because the 1 spot it taken up by the column name. Is there anyway to remove the A, B, C and put in my own column names? Thank you. Lisa H. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I replace A, B, C, Column names, with my own names? | Excel Discussion (Misc queries) | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
Replacing Range Names | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
replacing just the sheet names within formulas | Excel Worksheet Functions |