Sheet page setup

Print Specifies what is printed from the worksheet, whether the printout is in color or black and white, and what the print quality is. Gridlines Select the Gridlines check box to include worksheet gridlines in the printout. Gridlines are not printed by default, regardless of whether they are displayed on the worksheet or not. Black and white Select the Black and white check box when you use a color printer but you want to use black and white only when printing.

This option is off by default. You do not have to select it when you are using a printer that prints black and white only. Draft quality Select the Draft quality check box to print faster by using less print quality when the printer that you use has a draft-quality mode.

This option has no effect when the printer has no draft-quality mode. Row and column headings Select the Row and column headings check box to include these headings in the printout. Comments and notes In this box, select the location where you want annotations that you added to worksheet cells to appear in the printout.

Select At end of sheet to combine all annotations and print them together on a page that is added at the end of the printout. Select As displayed on sheet to print the annotations in their original location on the worksheet. Annotations are not automatically included in the printout, because None is selected by default.

Cell errors as In this box, select how you want cell errors that appear on the worksheet to be displayed in the printout. Page order Click Down, then over or Over, then down to control the order in which data is numbered and printed when it does not fit on one page.

The sample picture previews the direction your document will print when you choose one of these options. Repeat specific rows or columns on every printed page. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Preview worksheet pages before printing. The lines should be identical to the example lines provided here, except that the property Orientation can be changed as appropriate CenterFooter, PaperSize, and so on.

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Please rate your experience Yes No.

Any additional feedback? This is a guide to Page Setup in Excel. Here we discuss How to Setup Page in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Download Page -Setup- Excel- Template. Note: Not all of the data portion is visible in this screenshot. Popular Course in this category. Course Price View Course. It is just that, we wanted to make you aware of all the page layout settings in one single article. In the New Page Setup dialog box, enter the name of the page setup. In the Page Setup dialog box, specify the device and other page setup options and then choose OK. In the Page Setup Manager, select the named page setup you want to use for the current layout or model and choose Set Current.

All of the named page setups are saved in the current drawing but you can use the Import option to access named page setups from other drawings. Ideally, you would create all of your named page setups in a template file so that they are automatically included in new drawings and easily accessible from a central location to import into existing drawings.

Imagine that a design partner sent you a set of drawing files with sheets. You want to plot all of the sheets to fit on a letter-size paper using your LaserJet. Unfortunately, each of those layouts has been saved to plot to E-size paper on a DesignJet. Has this ever happened to you? What do you do? Using traditional methods, you probably open a drawing, select the layout, choose Plot, set the device, set the paper size, set the plot area, set the scale, and send it to the plotter.

And then, repeat the same process 99 more times! If you are a full-time plotter, you might think of it as job security! Otherwise, you probably consider it an incredible waste of your valuable time! Sheet set manager enables you to use named page setups to quickly plot an entire sheet set or any selected sheets within it to any page setup configuration.

When you create a new sheet set, AutoCAD uses a default template file for the named page setups.