Excel's vanishing page breaks


Q The page breaks I insert in my Excel worksheets do not happen when I print the worksheet or when I print a selection. I can't seem to establish what I am doing wrong.

û Bruce Davies

A This problem occurs when scaling is applied to the worksheet. If you tell Excel to size the worksheet to fit a specified number of pages (eg one page wide by one page tall), the application ignores all manual page breaks when printing.

Caption: Adjust Excel's scaling values to ensure that manually inserted page breaks are not ignored

To fix the problem, select FileûPage Setup and, on the Page tab, adjust the scaling to the desired percentage of normal size.

û Neville Clarkson


Category:Spreadsheet
Issue: September 1998

These Web pages are produced by Australian PC World © 1998 IDG Communications