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)?

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)?