Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change Column names (a,b,c to Name, Number)
I am trying to change the Columns titles. Example, Column A becomes Column
Name, Column B becomes Column, Address. That way when I'm working on row 57 I can still see which column the data goes in without having to scroll to the top and see which column is correct. I know I have done this before in a computer class, but not with the new Office systems. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change Column names (a,b,c to Name, Number)
I think you are talking about Freeze Panes. Look it up in Help. With this
you can freeze the column headers (your headers, not the A, B, C, etc) so that they will always be at the top of the screen no matter how far down you scroll. You cannot change the A, B, C etc. Usually you leave them alone and place your headers is some row, like row 1 maybe. You can, if you wish, set Excel to NOT display the A, B, C, etc and the row numbers. Look that up in Help as well. HTH Otto "cmw410" wrote in message ... I am trying to change the Columns titles. Example, Column A becomes Column Name, Column B becomes Column, Address. That way when I'm working on row 57 I can still see which column the data goes in without having to scroll to the top and see which column is correct. I know I have done this before in a computer class, but not with the new Office systems. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change Column names (a,b,c to Name, Number)
Highlight the row below heading, go to window and then "Freez panes", this
way you see your headings all the times. "cmw410" wrote: I am trying to change the Columns titles. Example, Column A becomes Column Name, Column B becomes Column, Address. That way when I'm working on row 57 I can still see which column the data goes in without having to scroll to the top and see which column is correct. I know I have done this before in a computer class, but not with the new Office systems. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you change Excel column names from ABC to 123? | Excel Discussion (Misc queries) | |||
How do I Change the Column Names (Re-Name A - | New Users to Excel | |||
How do you change the column names e.g. A B C D E F | Excel Discussion (Misc queries) | |||
How do you change the column names in Excel? | Excel Discussion (Misc queries) | |||
How do you change the column names,in Excel? | Charts and Charting in Excel |