Blogs

Printing in Excel - How?

   1) - Open, and then Preview the worksheet

1. Click the worksheet or select the worksheets that you want to preview.
2. Click File, and then click Print.  Keyboard shortcut    You can also press CTRL+P.

Note    The preview window will display in black and white, regardless of whether your worksheet(s) includes color, unless you are configured to print on a color printer.

3. To preview the next and previous pages, at the bottom of the Print Preview window, click Next Page and Previous Page.

Note    Next Page and Previous Page are available only when you select more than one worksheet, or when a worksheet contains more than one page of data. To view multiple worksheets, under Settings, click Print Entire Workbook.

  2) - Set printing options

1. To change the printer, click the drop-down box underPrinter, and select the printer that you want.
2. To make page setup changes, including changing page orientation, paper size, and page margins, select the options that you want under Settings.
3. To scale the entire worksheet to fit on a single printed page, under Settings, click the option that you want in the scale options drop-down box.

Tip  For information about how to specify headers and footers, see Page 2 of this document to “Use Headers and Footers”. For information about how to repeat specific rows or columns on printed pages, see Page 2 to “Repeat Specific Rows or Columns on Every Page”

  3) - Print all or part of the worksheet

1. To print the active sheet or sheets, or the entire workbook, underSettings, select the option that you want.
   
2. To print a portion of the worksheet, do the following:
3. Click the Home tab to return the worksheet, and then select the range of data that you want to print.
4. On the File tab, click Print.
5. Under Settings, click Print Selection. And then Click PRINT