| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the headings from A1 A2 etc to show my headings?
I have always been frustrated with this not being able to customize my
spreadsheets. Does anyone know how to find the place to go to change the headings for the columns so that I can specify what is in the columns instead of a1 a2 a3? I would rather it say "Date, Check# , description, amount, credit, balance". |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the headings from A1 A2 etc to show my headings?
You can simply select to not display the column letters (Tools - Options),
then enter your headers in row 1 as you please. HTH Otto "JaneyMae1" wrote in message ... I have always been frustrated with this not being able to customize my spreadsheets. Does anyone know how to find the place to go to change the headings for the columns so that I can specify what is in the columns instead of a1 a2 a3? I would rather it say "Date, Check# , description, amount, credit, balance". |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the headings from A1 A2 etc to show my headings?
You can't do that *exactly*. Closest thing: Use the first row to display your
headings. Then, select row 2, and go to Window - freeze panes. Then, if you want, you can go to tools - options, view tab, and hide the row&column headers. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JaneyMae1" wrote: I have always been frustrated with this not being able to customize my spreadsheets. Does anyone know how to find the place to go to change the headings for the columns so that I can specify what is in the columns instead of a1 a2 a3? I would rather it say "Date, Check# , description, amount, credit, balance". |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the headings from A1 A2 etc to show my heading
Thank you, I'm glad to know that I am not just dense! This will work...
"Luke M" wrote: You can't do that *exactly*. Closest thing: Use the first row to display your headings. Then, select row 2, and go to Window - freeze panes. Then, if you want, you can go to tools - options, view tab, and hide the row&column headers. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JaneyMae1" wrote: I have always been frustrated with this not being able to customize my spreadsheets. Does anyone know how to find the place to go to change the headings for the columns so that I can specify what is in the columns instead of a1 a2 a3? I would rather it say "Date, Check# , description, amount, credit, balance". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show headings on all pages Excel 2003 | Excel Discussion (Misc queries) | |||
| Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
| Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
| How do I show hidden column and row headings in excel? | Excel Discussion (Misc queries) | |||
| Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
Linear Mode
