Inserting Page Breaks

graphics/microsoft52.gif

If you want to print a worksheet that is larger than one page, Excel divides it into pages by inserting automatic page breaks . These page breaks are based on paper size, margin settings, and scaling options you set. You can change which rows or columns are printed on the page by inserting horizontal or vertical page breaks . In page break preview, you can view the page breaks and move them by dragging them to a different location on the worksheet.

Insert a Page Break

graphics/one_icon.jpg To insert a horizontal page break, click the row where you want to insert a page break.

To insert a vertical page break, click the column where you want to insert a page break.

graphics/two_icon.jpg

Click the Insert menu, and then click Page Break.

graphics/09inf21.jpg

Preview and Move a Page Break

graphics/one_icon.jpg

Click the View menu, and then click Page Break Preview.

graphics/two_icon.jpg

Drag a page break (a thick blue line) to a new location.

graphics/three_icon.jpg

When you're done, click the View menu, and then click Normal.

graphics/09inf22.jpg



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net