column headings
 

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,

column headings
 

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.

--
Kevin Backmann


"Pammy" wrote:

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,

column headings
 

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.

Pammy wrote:

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,

--

Dave Peterson