excel tutorialPrinting in Excel
This chapter teaches you how to print the entire Excel worksheet or just a selection. This chapter also illustrates how to change some important print settings, such as fitting a sheet on one page, printing gridlines and headings, adjusting page margins, and centering a range of cells on a page automatically.
Print a Worksheet
To print a worksheet in Excel 2010 (or Excel 2007), execute the following steps.
1. On the File tab, click Print.
2. To preview the other pages that will be printed, click 'Next Page' or 'Previous Page' at the bottom of the window.
3. To print the worksheet, click the big Print button.
Print Selection
Instead of printing the entire worksheet, you can also only print the current selection.
1. First, select the range of cells you want to print.
2. Next, under Settings, select Print Selection.
3. To print the selection, click the big Print button.
Fit Sheet on One Page
If you want to fit more data on one page, you can fit the sheet on one page. To achieve this, execute the following steps.
1. Under Settings, select 'Fit Sheet on One Page' from the Scaling drop-down list.
Print Gridlines & Headings
Printing gridlines (the horizontal and vertical lines you see on your worksheet) and row/column headers (1, 2, 3 etc and A, B, C etc) makes your copy easier to read. To print gridlines and headings, execute the following steps.
1. On the Page Layout tab, check Print under Gridlines and check Print under Headings.
Page Margins
To adjust the page margins, execute the following steps.
1. First, click on the 'Show Margins' icon at the bottom right window.
2. Next, you can drag the lines to change the page margins.
Center on Page
To center a range of cells on a page automatically, execute the following steps.
1. Under Settings, select 'Custom Margins' from the Margins drop-down list.
2. Next, check horizontally and vertically.
Did you like this free Excel tutorial? Show your appreciation, vote for us.