Sheet Options - Excel
Print Area: Using this option you can establish a specific print area. By default, Excel will select a print area that will incorporate the entire area of the worksheet that contains data. You may want to segment different areas for printing. To define a print area, click inside the print area field and type the print range desired or use the collapse button found to the right of the print area field to collapse the dialog box, then select the range directly in your worksheet. Once the range has been selected, click on the collapse button again to restore the dialog box. Click on OK when finished.
Print Titles with this option you can designate row and column headers that you want to have repeated on all pages of your report. Designate the rows to be repeated by typing in the row numbers (i.e., 1:3) in the "Rows to repeat at top" field. Alternatively, you can use the collapse button found to the right of the "Rows to repeat at top" filed to select the desired rows.
Similarly, type in the columns to be repeated by typing in the desired columns letters in the "Columns to be repeated at left" field (i.e., A:B) to be repeated. Alternatively, you can use the collapse button found to the right of the "Columns to repeat at top" filed to select the desired rows.
Print: this sections provides options to control
• Print or not print gridlines
• Print in Black and White
• Print in Draft Quality
• Print the Row and Column Letters and Numbers
• Print comments either as displayed on the worksheet or at the end of the worksheet
• Print cell errors as displayed, blank or N/A
Print Order: Choose to order multiple pages of your report
• Down then over thus it will print all pages down before printing pages to the right
• Over then down thus it will print pages left to right before printing pages below
When all of your options have been selected, click on OK to close the Page SetUp dialog box.
This site needs an editor - click to learn more!
You Should Also Read:
Page SetUp Dialog Box - Excel
Print Preview - Excel
Page Options - Excel
Editor's Picks Articles
Top Ten Articles
Content copyright © 2021 by Chris Curtis. All rights reserved.
This content was written by Chris Curtis. If you wish to use this content in any manner, you need written permission. Contact BellaOnline Administration for details.