Page 4 of 23PREVNEXT

So that's how! Printing options in Excel

Play the animation to see a two-page worksheet become a one-page worksheet when a column is narrowed by using the margin handles.

Imagine that you're looking at your worksheet in print preview. In the bottom left corner of the screen, it says "Preview: Page 1 of 2", so you know that if you print, you'll get two pages. But you want to get your data printed on just one page.

You click Next at the top of print preview to see what the second page looks like. There's just one column, the Supplier column, on page 2.

Because you only need to move that one column to get a single-page printout, there's an easy way. If you make one or more columns on page 1 narrower, you can pull the last column onto page 1.

How do you do that? In print preview, click Margins. You'll see black square margin handles at the top of the page. You can drag these handles to change the margins, and you can also drag the handles to change column widths.

So you find a column that's fairly wide, and you drag the margin handle to narrow it. That extra space moves the last column onto the page. Click Play to watch the process of adjusting a column.

Note     The changes you make in print preview also change the width of the columns in the worksheet itself, not just in the preview or printing of the data.

Important     When you change the width of a column, some of the data in that column could be hidden. Before you print, look at the data in the column you adjusted to make sure you can still read everything in that column. If any of the data is hidden, you can wrap text so that it appears on more than one line and is all visible again. You'll see how in the practice.

Page 4 of 23PREVNEXT