Search results
Results from the WOW.Com Content Network
Page breaks are dividers that break a worksheet into separate pages for printing. 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 undo a split, simply click View > Window > Split again. Splitting a worksheet lets you see two regions at the same time in different panes by scrolling in each pane. It freezes panes while you scroll in one of the panes.
If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu. When an Excel worksheet spans more than one page, you can print row and column headings (also known as headers or labels) on every page.
On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area. Note: The print area that you set is saved when you save the workbook. To see all the print areas to make sure they’re the ones you want, click View > Page Break Preview in the Workbook Views group.
On the View tab, in the Workbook Views group, click Page Break Preview. You can insert new manual page breaks and move and delete automatic page breaks. For more information, see Add, delete, or move page breaks .
By scaling your worksheet for printing, you can make your data fit to one page. You can shrink your Excel document to fit data on a designated number of pages using the Page Setup option in the Page Layout tab.
If a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page. For example, you can repeat the first row of column headers on all pages when you have large, complex worksheets.
Page break. Divider that breaks a worksheet into separate pages for printing. Excel inserts automatic page breaks based on the paper size, margin settings, scaling options, and the positions of any manual page breaks that you insert. Page break preview. Worksheet view that displays the areas to be printed and the locations of page breaks.
You can use a custom view to save specific display settings (such as hidden rows and columns, cell selections, filter settings, and window settings) and print settings (such as page settings, margins, headers and footers, and sheet settings) for a worksheet so that you can quickly apply these settings to that worksheet when needed.
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns. In this article, find all workbook, worksheet, and feature specifications and limits.