If you want to print one worksheet just the way it is without changing any print options, simply click the Print button on the Standard toolbar. But suppose you want to print more than one worksheet. No problem—you just need to tell Excel which worksheets you want to print. You can print contiguous or noncontiguous worksheets.
- Contiguous worksheets—Worksheets that are next to each other in the workbook, without any worksheet that you don’t want in between them
- Noncontiguous worksheets—Worksheets that are separated by several worksheets that you do not want
Printing Gridlines
By default, Excel worksheets print without gridlines, which separate the cells as it looks cleaner without the grids. However, to change overall appearance of worksheet by printing the gridlines follow the steps
- Click the File menu and choose Page Setup.
- In Sheet tab click Gridlines check box to put a check mark in the box.
- Print the worksheet from the Page Setup dialog box. Click the Print button.
- Click OK in the Print dialog box to print the worksheet. Worksheet will print with
Printing a Range
You can choose which pages you want to print in the Print Range area in the Print dialog box. You have two choices: All or Pages. Printing all the pages in your active sheet is the default print range setting. However, you can print specific pages by choosing the Page(s) option and entering the page numbers in the From and To boxes.
Printing a Selection
To print a portion of the worksheet select the cells, rows, and/or columns you want to print. Then click File, Print. In the Print dialog box, in the Print this option prints only the portion of the worksheet you selected.
Printing the Entire Workbook
You can print the entire workbook with all its worksheets in one step. In File menu, Click Print option and in the Print dialog box, choose Entire Workbook. This option prints the whole workbook.
Printing Column and Row Headings
You can select titles that are located on the top edge (column headings) and left side (row headings) of your worksheet and print them on every page of the printout. The steps are
- Click File, Page Setup and click the Sheet tab. You see the Sheet options
- Click in the Rows To Repeat At Top text box
- Click in worksheet and select and drag to include the title, subtitle, and column headings to repeat
- Click in the Columns to Repeat at Left text box
- Click on any cell in column A to include the row headings
- Click OK to confirm your choices. All data above and to the left of the dashed-line border (print area) repeat on every page