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 under Headings. 2. On the…
Tag: Print
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 the top of each printed…
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 add the page number. 4.…
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 tab, in the Header &…
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 a solid line (manual page…
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 the print area is printed.…
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 another page. These steps teaches you how to print a worksheet and how to…
How to choose page/paper size in Excel before Printing
1. How do you know which paper size when you want to print in Excel? 2. Selecting a Paper Size Working excel files is one thing, knowing what paper size to print completed work is another. 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…
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 tables that track expenditures over…