changing column headings

W

Wang

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
 
B

Bob Phillips

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.
 
Top