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". |
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". |
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". |
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". |
All times are GMT +1. The time now is 09:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com