HomeApplicationOffice information

How to Print Part of an Excel Spreadsheet

Excel sheets can compile a lot of data, and it's not always convenient to print it all at once. You can print certain sections of a spreadsheet by highlighting the target area, going to the print settings, and choosing the 'print selected...
Method 1 of 3:

Printing from a Selection

  1. How to Print Part of an Excel Spreadsheet Picture 1How to Print Part of an Excel Spreadsheet Picture 1
    Open your Excel worksheet. Double-click the worksheet or go to 'File > Open' in Excel.
  2. How to Print Part of an Excel Spreadsheet Picture 2How to Print Part of an Excel Spreadsheet Picture 2
    Highlight the cells that you want to print. Click and hold the first cell in the range and drag the cursor until you've highlighted all the cells that you want to print.
  3. How to Print Part of an Excel Spreadsheet Picture 3How to Print Part of an Excel Spreadsheet Picture 3
    Go to the 'File' menu and select 'Print'. The menu is in the top left corner of your screen and brings up 'Print Settings'.
  4. How to Print Part of an Excel Spreadsheet Picture 4How to Print Part of an Excel Spreadsheet Picture 4
    Choose 'Print the selection'. Below the selected printer device is a dropdown menu to select which part of the workbook you wish to print. This selection will set the print to use only the area of the spreadsheet you have highlighted.
  5. How to Print Part of an Excel Spreadsheet Picture 5How to Print Part of an Excel Spreadsheet Picture 5
    Press 'Print'. The button is located at the top of the menu. All content except your selection will be excluded from the print.
Method 2 of 3:

Using a Print Area

  1. How to Print Part of an Excel Spreadsheet Picture 6How to Print Part of an Excel Spreadsheet Picture 6
    Open your Excel worksheet. Double-click the worksheet or go to 'File > Open' in Excel.
  2. How to Print Part of an Excel Spreadsheet Picture 7How to Print Part of an Excel Spreadsheet Picture 7
    Highlight the cells that you want to print. Click and hold the first cell in the range and drag the cursor until you've highlighted all the cells that you want to print.
  3. How to Print Part of an Excel Spreadsheet Picture 8How to Print Part of an Excel Spreadsheet Picture 8
    Go to the 'Page Layout' tab. This tab is located in the top menu bar, a few options to the right of the 'File' menu. Here you can access a number of settings to format your spreadsheet. Among these options is 'Print Area'.
  4. How to Print Part of an Excel Spreadsheet Picture 9How to Print Part of an Excel Spreadsheet Picture 9
    Set the Print Area. Press 'Print Area' and select 'Set Print Area' from the dropdown. The highlighted cells will be designated to the print area. This area will be saved for future printing and you can continue to work.
    1. The 'Orientation' button switches between landscape and portrait orientation.
    2. The 'Margins' button adjusts the margins on a printed page.
    3. 'Scale to Fit' chooses how many pages you want to fit your printed content into.
    4. You can clear, overwrite or add to the print area from the same dropdown menu.
  5. How to Print Part of an Excel Spreadsheet Picture 10How to Print Part of an Excel Spreadsheet Picture 10
    Go to 'File' and select 'Print'. The menu is in the top left corner of your screen and brings up 'Print Settings'.
  6. How to Print Part of an Excel Spreadsheet Picture 11How to Print Part of an Excel Spreadsheet Picture 11
    Adjust the print settings. In the dropdown menu under the printer device, make sure 'Print Active Sheet(s)' is selected and that the 'Ignore Print Area' checkbox is NOT selected.
    1. Note that 'Print the selection' means that any newly highlighted selection overrides your designated print area.
  7. How to Print Part of an Excel Spreadsheet Picture 12How to Print Part of an Excel Spreadsheet Picture 12
    Press 'Print'. The button is located at the top of the menu, and the page will print with your print area and page layout adjustments.
Method 3 of 3:

Printing Individual Sheets From a Workbook

  1. How to Print Part of an Excel Spreadsheet Picture 13How to Print Part of an Excel Spreadsheet Picture 13
    Open an Excel file with multiple sheets. In a large workbook, there may be only one or two sheets you want printed. In Excel, go to the 'File' menu and select 'Open' or simply double-click an Excel file.
  2. How to Print Part of an Excel Spreadsheet Picture 14How to Print Part of an Excel Spreadsheet Picture 14
    Select the sheet(s) you want to print. Click the sheet name in the bottom bar. Multiple sheets can be selected using Ctrl + click (⌘ Cmd + click on Mac).
  3. How to Print Part of an Excel Spreadsheet Picture 15How to Print Part of an Excel Spreadsheet Picture 15
    Go to the 'File' menu and select 'Print'. The menu is in the top left corner of your screen and brings up 'Print Settings'.
  4. How to Print Part of an Excel Spreadsheet Picture 16How to Print Part of an Excel Spreadsheet Picture 16
    Select 'Print Active Sheet(s)'. The first option below the selected printer device is a dropdown menu to select which areas of the workbook to print. 'Print Active Sheet(s)' will set the printer to only print the sheets you selected instead of the entire workbook.
  5. How to Print Part of an Excel Spreadsheet Picture 17How to Print Part of an Excel Spreadsheet Picture 17
    Adjust other print settings. Dropdown menus below the selection menu allow you to adjust layout options like page orientation or margins from this panel.
    1. If you previously set a print area but decide against using it, select 'Ignore Print Areas' to ignore.
  6. How to Print Part of an Excel Spreadsheet Picture 18How to Print Part of an Excel Spreadsheet Picture 18
    Press "Print". The button is located at the top of the menu and your selected sheets will print, excluding the others.
4.5 ★ | 4 Vote
printmenuareaselect

You should read it

May be interested

Office information