Excel OfficePrint 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 Gridlines and check Print… read more »
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 row 1 at… read more »
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 Page Number to… read more »
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 activates. 3. On the Design… read more »
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 displays… read more »
A print area is one or more ranges of cells that you designate to print when you don’t want to print the entire worksheet. If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. When you print a worksheet after defining a print area, only… read more »
How to setup and print Excel worksheets. Print a Worksheet What to Print Multiple Copies Change Page Orientation Adjust Page Margins Use Scaling to Fit Sheet on One Page Excel obviously allows you to print your worksheets to a printer. Sometimes a worksheet will fit on a single page, but other times it will flow to… read more »
Selecting a Paper Size In most cases, you’ll use the standard 8.5-x-11-inch letter-sized paper to print your worksheets. However, if you find that you need to print on 8.5-x-14-inch legal paper size, an envelope, or another paper size, you must tell Excel which size paper you want to use. Choose a page size Select the Page… read more »
— Print a worksheet in landscape or portrait orientation Default paper orientation is mostly portrait. Excel can fit three more columns of information on the page in landscape mode than it can in portrait mode. 2 Ways to change page orientation in Excel Because many worksheets are wider than they are tall (such as budgets or sales… read more »