If you set a print area in Excel, only that area will be printed. The print area is saved when you save the workbook. To set a print area, execute the following steps. 1. Select a range of cells. 2. On the Page Layout tab, in the Page Setup group, click Print Area. 3. Click […]
Print gridlines (the horizontal and vertical lines on your worksheet) and row/column headers (1, 2, 3 etc. and A, B, C etc.) to make your printed copy easier to read. To print gridlines and headings in Excel, execute the following steps. 1. On the Page Layout tab, in the Sheet Options group, check Print under […]
To center a range of cells on a printed page in Excel automatically, execute the following steps. 1. On the File tab, click Print. 2. Click ‘Custom Margins’ from the Margins drop-down list. 3. Next, check horizontally and vertically. 4. Click OK. .
You can specify rows and columns in Excel that will be printed on each printed page. This can make your printed copy easier to read. To print titles, execute the following steps. 1. On the Page Layout tab, in the Page Setup group, click Print Titles. The Page Setup dialog box appears. 2. To repeat […]
This example teaches you how to print page numbers in Excel. 1. On the View tab, in the Workbook Views group, click Page Layout, to switch to Page Layout view. 2. Click Add footer. The Header & Footer Tools contextual tab activates. 3. On the Design tab, in the Header & Footer Elements group, click […]
This example teaches you how to add information to the header (top of each printed page) or footer (bottom of each printed page) in Excel. 1. On the View tab, in the Workbook Views group, click Page Layout, to switch to Page Layout view. 2. Click Add header. The Header & Footer Tools contextual tab […]
Insert a page break in Excel to specify where a new page will begin in the printed copy. To insert a horizontal page break, execute the following steps. 1. Select the first row of the new page. 2. On the Page Layout tab, in the Page Setup group, click Breaks. 3. Click Insert Page Break. […]
Excel offers three workbooks views, Normal, Page Layout and Page Break Preview.Normal At any time, you can switch back to Normal view. 1. On the View tab, in the Workbook Views group, click Normal. Result: Note: if you switch to another view and return to Normal view, Excel displays page breaks. Close and reopen the […]
This chapter teaches you how to print a worksheet and how to change some important print settings in Excel. Print a Worksheet To print a worksheet in Excel, execute the following steps. 1. On the File tab, click Print. 2. To preview the other pages that will be printed, click ‘Next Page’ or ‘Previous Page’ […]
Insert a page break in Excel to specify where a new page will begin in the printed copy. To insert a horizontal page break, execute the following steps. 1. Select the first row of the new page. 2. On the Page Layout tab, click Breaks, Insert Page Break. Excel displays a dashed line to show […]
Excel offers three workbooks views, Normal, Page Layout and Page Break Preview. Normal At any time, you can switch back to Normal view. 1. On the View tab, click Normal (or click the Normal icon in the status bar). Note: if you switch to another view and return to Normal view, Excel displays page breaks. […]
This chapter teaches you how to print a worksheet and how to change some important print settings in Excel. Print a WorksheetTo print a worksheet in Excel 2010, execute the following steps. 1. On the File tab, click Print. 2. To preview the other pages that will be printed, click ‘Next Page’ or ‘Previous Page’ […]
