viewing page breaks in excel for mac 2011

Viewing Page Breaks In Excel 2011 Manual Page Breaks

You can also easily include important date and time information.

You can work with headers and footers in Page Layout view by choosing ViewPage Layout or clicking the Page Layout button in the Layout tab of the Office 2011 for Mac Ribbon.

Similarly, you can move the cursor over the white space near the bottom of a page to add or format a footer.

Youre in the left, right, or center region, depending on where you double-click.

For example, use Insert Page Number and Insert Number of Pages with additional text like this: Page Page of Pages to print Page of.

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

To delete a horizontal page break, select the row below the page break that you want to delete.

Viewing Page Breaks In Excel 2011 Manual Page Breaks

Microsoft Excel inserts automatic page breaks based on the paper size, margin, settings, scale options, and the positions of any manual page breaks that you insert.

To print a worksheet with the exact number of pages that you want, you can adjust the page breaks in the worksheet before you print it.

For example, you can see how a change that you make to the row height and column width affects the placement of the automatic page breaks.

To override the automatic page breaks that Excel inserts, you can insert your own manual page breaks, move existing manual page breaks, or delete any manually-inserted page breaks.

After you finish working with page breaks, you can return to Normal view.

In Page Break Preview, dashed lines are page breaks Excel automatically added.

Insert a page break Click the worksheet that you want to print.

On the View tab, in the Workbook View group, click Page Break Preview.

Do one of the following: To insert vertical page break, select the row below where you want to insert the page break.

To insert a horizontal page break, select the column to the right of where you want to insert the page break.

On the Page Layout tab, in the Page Setup group, click Breaks.

You can also right-click the row or column below or to the right of where you want to insert the page break, and then click Insert Page Break.

If manual page breaks that you insert do not take effect, it may be that the Fit To scaling option has been selected on the Page tab of the Page Setup dialog box ( Page Layout tab, Page Setup group, Dialog Box Launcher).

To use the manual page breaks, change the scaling to Adjust to instead.

Move a page break Note: To enable dragging of page breaks to another location in a worksheet, make sure that the cell drag-and-drop feature is enabled.

If this feature is not enabled, you may not be able to move any page breaks.

To verify that drag-and-drop is enabled, do the following: Click the File tab Options.

In the Advanced category, under Editing options, select the Enable fill handle and cell drag-and-drop check box then click OK.

On the View tab, in the Workbook Views group, click Page Break Preview.

Note: Moving an automatic page break changes it to a manual page break.

Delete a page break Select the worksheet that you want to modify.

Do one of the following: To delete a vertical page break, select the column to the right of the page break that you want to do delete.

Viewing Page Breaks In Excel For Mac 2011