changing column headings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to know how to change the column and row heading names, like "A2" to
read a name like "Atlanta". So that when it prints it will print the header
of Atlanta vs the "A2" on my mulit page worksheet. Any help out there?
Thanks Gary
 
You could put your headings in row 1, suppress column headings,
Tools>Options and uncheck row and column headings, and set row 1 as a print
heading, File>Page Setup>Sheet and set rows to repeat as $1:$1.
 
You must log in or register to reply here.

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 Copy cells from one worksheet to another workseet - increment row & do again 0
Referencing Worksheets 4
VLOOKUP Help Needed 3
Column Heading Error 3
Count(s) in Pivot Table 4
Print separate reports with same column heading 4
Rotate column headings - ??? 3
How do I change the headings from A1 A2 etc to show my headings? 3

Back
Top