Print in Excel

Print Gridlines and Headings in Excel

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 Gridlines and check Print… read more »

How to ‘Center on Page’ Print in Excel

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.

Print Titles in Excel Worksheets

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 »

Print Page Numbers in Excel

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 »

Print Headers and Footers in Excel

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 »

How to Break Worksheets into Pages in Excel

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 »

How to set or clear a print area in Excel Worksheet

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 »

Print in Excel

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 »

Choose page/paper size in Excel before Printing

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 »

How To Change Paper Orientation In Excel

— 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 »

Sidebar