When you need to print only a specific section of your worksheet, rather than the entire document, Microsoft Excel provides a handy feature. This article guides you through the process of printing a selected area of your worksheet.
Before we delve into the steps, ensure you have selected the specific area you want to print. You can do this by clicking and dragging your cursor over the required cells. Only the selected area will be affected, so be precise with your selection.
Setting Up Your Print Area
The first step is to define the print area in your worksheet. This area will be the only one Excel considers when giving print commands.
To set the print area, follow these steps:
Defining the Print Area
1. Select the area you want to print. This can be a range of cells, a table, or even a chart.
2. Click the 'Page Layout' tab in the ribbon, then click 'Print Area' in the 'Page Setup' group. A dropdown menu will appear.
3. Select 'Set Print Area' from the dropdown menu. Now, only the selected area will print.
Printing the Selected Area
Once you've defined the print area, you can proceed to print the selected content.
1. Press Ctrl + P (or Command + P on a Mac) to open the Print dialog box.
2. Ensure the correct printer is selected in the 'Printer' section, then click 'Print'. Only the previously defined print area will be printed.
Manipulating the Print Area
Excel allows you to adjust the print area to better suit your needs.
Here are two common adjustments you might need to make:
Changing the Print Area
You can change the print area at any time. To do this, simply follow the steps under 'Defining the Print Area' and select a new area.
To delete the print area entirely and print the entire worksheet again, click 'Clear Print Area' in the 'Page Setup' group of the 'Page Layout' tab.
Printing Multiple Areas
If you need to print more than one area, you can do so by defining each area as a print area, as described above. Then, print the document as you usually would.
Excel will print each defined print area on separate pages.
That's it! You've now mastered the art of printing selected areas from your worksheet. This feature can save you a significant amount of paper and ink, making it a valuable tool for anyone working with large or complex worksheets.