Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an Index by Column Headings instead of Column Numbers | New Users to Excel | |||
How do I take information in 1 column to make column headings? | Excel Discussion (Misc queries) | |||
How do I create column headings in Excel in the A, B, C etc column | Excel Discussion (Misc queries) | |||
column headings | Excel Worksheet Functions | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions |