Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
re-name colomns i.e A,B,C, etc
in excel i have made a sheet using drop down list boxes for different things
to enter in cells also colomns with the 'now' time function, how do i re-name colomns i.e A,B,C, etc (if I can) so I can see what colomn is what as the sheet goes down. I am quite a novice at this and have done everything from ms help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
re-name colomns i.e A,B,C, etc
See if I'm on the right track here.....
If you want to be able to scroll down the worksheet, but still see the headings for your data, try this 1)Make sure your data has column headings Example: A1: MyDate A2:A100 (contains dates) B1: MyAmount B2:B100 (contains amounts) etc Select B2 From the Excel main menu: <window<freeze panes That will make sure you ALWAYS see Row_1 and Col_A to undo that setting: <window<UNfreeze panes Does that help? *********** Regards, Ron XL2002, WinXP "swede" wrote: in excel i have made a sheet using drop down list boxes for different things to enter in cells also colomns with the 'now' time function, how do i re-name colomns i.e A,B,C, etc (if I can) so I can see what colomn is what as the sheet goes down. I am quite a novice at this and have done everything from ms help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
re-name colomns i.e A,B,C, etc
The easiest way is to put your column headers in the first row and then
select cell A2 and pull-down: Windows Freeze Panes -- Gary's Student "swede" wrote: in excel i have made a sheet using drop down list boxes for different things to enter in cells also colomns with the 'now' time function, how do i re-name colomns i.e A,B,C, etc (if I can) so I can see what colomn is what as the sheet goes down. I am quite a novice at this and have done everything from ms help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
re-name colomns i.e A,B,C, etc
Thanks Ron that done the trick, absolutley wonderful
"Ron Coderre" wrote: See if I'm on the right track here..... If you want to be able to scroll down the worksheet, but still see the headings for your data, try this 1)Make sure your data has column headings Example: A1: MyDate A2:A100 (contains dates) B1: MyAmount B2:B100 (contains amounts) etc Select B2 From the Excel main menu: <window<freeze panes That will make sure you ALWAYS see Row_1 and Col_A to undo that setting: <window<UNfreeze panes Does that help? *********** Regards, Ron XL2002, WinXP "swede" wrote: in excel i have made a sheet using drop down list boxes for different things to enter in cells also colomns with the 'now' time function, how do i re-name colomns i.e A,B,C, etc (if I can) so I can see what colomn is what as the sheet goes down. I am quite a novice at this and have done everything from ms help |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
re-name colomns i.e A,B,C, etc
thanks gary, ron beat you to it with the same answer, but thanks anyway
"Gary''s Student" wrote: The easiest way is to put your column headers in the first row and then select cell A2 and pull-down: Windows Freeze Panes -- Gary's Student "swede" wrote: in excel i have made a sheet using drop down list boxes for different things to enter in cells also colomns with the 'now' time function, how do i re-name colomns i.e A,B,C, etc (if I can) so I can see what colomn is what as the sheet goes down. I am quite a novice at this and have done everything from ms help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I switch from 1,2,3... back to A,B,C... column reference na | Excel Discussion (Misc queries) | |||
How do I display an excel wrksht without column headings (A,B,C)? | Excel Discussion (Misc queries) | |||
In Excel the colums which used to be A,B,C D etc are now 1,2,3 | Excel Discussion (Misc queries) | |||
how to get more than 256 colomns in excel sheet ? | Excel Discussion (Misc queries) | |||
Is there any way to increase the colomns in Excel more than 256 ? | Excel Discussion (Misc queries) |