| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vertical page breaks - one per column
I have a spreadsheet that is 40 columns wide, and except for the 1st column
(which will be repeated at the left), I want a page break after each column. Is there a quick way to do this (as opposed to going into Page Break Preview and pulling over the right page break 40 times)? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vertical page breaks - one per column
Try going into Print Preview and increasing the left and right margins by
dragging inwards. You should be able to narrow it down to one column per page. Gord Dibben MS Excel MVP On Fri, 8 Jan 2010 14:29:01 -0800, Staceyglow wrote: I have a spreadsheet that is 40 columns wide, and except for the 1st column (which will be repeated at the left), I want a page break after each column. Is there a quick way to do this (as opposed to going into Page Break Preview and pulling over the right page break 40 times)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't move my page breaks in Page Break Preview | Excel Discussion (Misc queries) | |||
| Vertical page breaks won't drag in Page Break Preview | Excel Discussion (Misc queries) | |||
| Different Page Numbers In Worksheet w/Page Breaks | Excel Discussion (Misc queries) | |||
| How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
| Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) | |||
Hybrid Mode
