Vertical page breaks - one per column

S

Staceyglow

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page Break 7
Setting Page Breaks 10
Total width of several columns. 2
HI!Need to make Cell formula change for each Pg Break in a Print T 1
Insert Multiple Page Breaks 1
Excel 2003 Page Breaks 2
Printing a Different Row Heading Mid-way through a Spreadsheet 1
Fixing Page Breaks 3

Top