Thread: column headings
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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