Sometimes there is so much data on an Excel worksheet that it is inconvenient to print it. Therefore, you can print a specific area of the table; to do this, select the cells, open the print settings and select the "Print selection" option. Likewise, you can print specific sheets of an Excel workbook. You can also change the format of the printable area before opening the print menu.
Steps
Method 1 of 3: Using the Print Selection option
Step 1. Open an Excel spreadsheet
Double-click the Excel file, or start Excel and click File> Open.
Step 2. Select the cells you want to print
Click and hold the first cell you want, and then drag the cursor to select all the cells you want.
Step 3. Click File> Print
The File menu is in the upper left corner of the screen. The Print page opens.
Step 4. Click "Print Selection"
Do this from the menu under the menu with a list of installed printers. Only the selected cells will be printed.
Step 5. Click "Print"
This button is located at the top of the menu. The selected cells will be printed on paper.
Method 2 of 3: Using the Printable Area option
Step 1. Open an Excel spreadsheet
Double-click the Excel file, or start Excel and click File> Open.
Step 2. Select the cells you want to print
Click and hold the first cell you want, and then drag the cursor to select all the cells you want.
Step 3. Click on the Page Layout tab
It is located on the top menu bar (to the right of the File tab and the other two tabs). On this tab, you can change the formatting of the table. Find the "Printable area" option among the options.
Step 4. Set the print area
Click Print Area> Set. The selected cells will be assigned as the printable area. This area will be saved, that is, you can continue to work with the table.
- Click Orientation to choose portrait or landscape orientation.
- Click Margins to change the margins of the printed page.
- The "Fit to" option will help you to specify the maximum number of sheets on which the specified printable area will be printed.
- In the same menu, you can clear, overwrite or add content to the print area.
Step 5. Click File> Print
The File menu is in the upper left corner of the screen.
Step 6. Change the print settings
In the drop-down menu under the menu with the list of installed printers, select the option "Print active sheets" and uncheck the box next to "Ignore printable area".
Note that if you select the Print Selection option, the selected cells will be printed, not the specified print area
Step 7. Click "Print"
This button is at the top of the menu. The specified print area will be printed.
Method 3 of 3: How to print single sheets
Step 1. Open an Excel spreadsheet with multiple sheets
Double-click the Excel file, or start Excel and click File> Open.
Step 2. Select the sheet (s) you want to print
To do this, click on the sheet name in the lower pane. To select multiple sheets, hold Ctrl (⌘ Cmd on Mac OS X) and click on each sheet you want.
Step 3. Click File> Print
The File menu is in the upper left corner of the screen.
Step 4. Select the "Print active sheets" option
Do this in the drop-down menu under the menu with the list of installed printers. Only the selected sheets will be printed, not the entire book.
Step 5. Change other print options
Do this in the menus below the Print Active Sheets option. Here you can choose page orientation or change margins.
If you have already set a printable area, but decide not to use it, check the box next to "Ignore printable areas"
Step 6. Click "Print"
This button is at the top of the menu. Only the sheets you selected will be printed.
Advice
- When you set the print area, open the preview window to see which portion of the table will be printed.
- To print the entire table after you set the print area, click Page Layout> Print Area> Remove.
Warnings
- Only one printable area can be set at a time.
- If you select several fragments of the table and set them as one printable area, each fragment will be printed on a separate sheet.