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

Two columns followed by single page-width column on same page 0
Getting a page break to take 0
Format column widths from one table to a separate table on same page 1
detect when columns being written to a worksheet “cross” a vertical page break 0
Two columns : Continuous two columns vs Parallel two Column 1
Setting Page Breaks 10
Column Break 3
Page Break 7

Top