column headings

G

Guest

Is there a way to print column headings? I have columns a-pp and I would
like to print just the headings listed one under the other. I will need this
in several spreadsheets and this would be helpful just to print a list of the
headings without having to scroll over to the right to view them.

Thanks,
 
G

Guest

Copy the entire heading row and then move to a blank worksheet and click EDIT
in the menu, select PASTE SPECIAL and check the TRANSPOSE check box to place
all of your headings in a single column.
 
D

Dave Peterson

So your column headings are in A1:pP1

Insert a new worksheet
Select that original A1:pP1
Edit|Copy
Select A1 of the new sheet
Edit|Paste special|Click transpose

Format that column (width & borders???)

And print that.
 

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

Top