How do I change the headings from A1 A2 etc to show my headings?

  • Thread starter Thread starter JaneyMae1
  • Start date Start date
J

JaneyMae1

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".
 
You can simply select to not display the column letters (Tools - Options),
then enter your headers in row 1 as you please. HTH Otto
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel =SUM(A1=A1+B1) 0
I need a formula for if cells a1 and a2 are the same then cell a3 3
How is "A1<=A2<=A3" evaluated? 1
A1-A2/A2, A2-A3/A3, A3-A4/A4...etc. how do i do this for the whole column?[/ 3
How do I evaluate A1 from cell A2 and place a value into A3? 5
how do I sort data excluidng headings? 2
Can I change the column heading from alphabetic to numeric? 2
Column headings 2

Back
Top