Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have seen spreadsheets where the column heads, A, B, C etc have titles but
haven't been able to figure out how to insert my own. thanks for any enlightenment on this topic. -- Elianna |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can't. You can REMOVE the display of the headings and insert your own in
row 1 then freeze row 1 so it always shows, but you're still really typing in columns A, B, etc. To remove the display of the headings: tools/Options/View tab, deselect Row & Column Headers To freeze row 1: Select row 2, Window/Freeze Panes. Bob Umlas Excel MVP "eliannaj" wrote in message ... I have seen spreadsheets where the column heads, A, B, C etc have titles but haven't been able to figure out how to insert my own. thanks for any enlightenment on this topic. -- Elianna |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can't change the "A,B,C,D..." column headings to something custom (you
can change them to numbers by going Tools-Options-'General' Tab- Check R1C1 reference style). The best you can do is place your custom column headings in row 1, then grab the little horizontal bar located at the top of the vertical scroll bar and drag it below row 1. Then Window-Freeze Panes. -- Regards, Dave "eliannaj" wrote: I have seen spreadsheets where the column heads, A, B, C etc have titles but haven't been able to figure out how to insert my own. thanks for any enlightenment on this topic. -- Elianna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In excel, how can I create a towards column in a single box? | Excel Worksheet Functions | |||
TYPING COLUMN HEADINGS IN EXCEL! | Excel Discussion (Misc queries) | |||
How do i change column headings back to letters in excel? | Excel Discussion (Misc queries) | |||
Excel worksheet column headings in backwards alphabetical order? | Excel Discussion (Misc queries) | |||
How do I create a column label in Excel? | New Users to Excel |