Search results
Results from the WOW.Com Content Network
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.
The Show sheet tabs setting is turned off. First ensure that the Show sheet tabs is enabled. To do this, For all other Excel versions, click File > Options > Advanced—in under Display options for this workbook—and then ensure that there is a check in the Show sheet tabs box.
Compare two worksheets in the same or different workbooks by viewing them side by side. You can also arrange multiple worksheets so that you can compare them.
Select the worksheet that you want to print. On the Page Layout tab, in the Page Setup group, select Print Titles. Note: The Print Titles command will appear dimmed if you are working in cell editing mode, if a chart is selected on the same worksheet, or if you do not have a printer installed.
Applies To. Newer versions Web. By default, gridlines don't appear on a printed Microsoft Excel worksheet or workbook. This article describes how you can make the gridlines appear in your printed worksheets. Select the worksheet or worksheets that you want to print.
Insert, move, or delete page breaks in a worksheet. Applies To. Windows Web. 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.
Fill cells with solid colors. Select the cells that you want to apply shading to or remove shading from. For more information on selecting cells in a worksheet, see Select cells, ranges, rows, or columns on a worksheet. On the Home tab, in the Font group, do one of the following:
Open the workbook you want to use as a template. Click File > Export. Under Export, click Change File Type. In the Workbook File Types box, double-click Template. In the File name box, type the name you want to use for the template. Click Save, and then close the template.
Gridlines are the faint lines that appear around cells to distinguish them on the worksheet. By default, gridlines are displayed in worksheets using a color that is assigned by Excel. Gridlines are always applied to the whole worksheet or workbook, and can't be applied to specific cells or ranges.
To summarize and report results from separate worksheets, you can consolidate data from each sheet into a master worksheet. The sheets can be in the same workbook as the master worksheet, or in other workbooks.
Sheet Views is an innovative way of letting you create customized views in an Excel worksheet without being disrupted by others. For instance, you can set up a filter to display only the records that are important to you, without being affected by others sorting and filtering in the document.