Download ArticleLearn how to print only a section of a large Excel workbook
Download ArticleX
This article was co-authored by How.com.vn Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. How.com.vn's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 326,061 times.
Learn more...
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 area’ option. A similar process can be used to print selected sheets in a workbook. “Print Areas” can also be used to for those who wish to adjust their formatting before entering the print menu.
Things You Should Know
- You can select the cells you want to print and then go to File and then Print and select Print the selection.
- You can edit the print area of the sheet to only print the part you want by going to the Page Layout tab.
- By selecting Print Active Sheets in the print menu, you will only print the sheets you have selected in a larger workbook.
Steps
Open your Excel worksheet. Double-click the worksheet or go to “File > Open” in Excel.
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.Advertisement
Go to the “File” menu and select “Print”. The menu is in the top left corner of your screen and brings up “Print Settings”.
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.
Press “Print”. The button is located at the top of the menu. All content except your selection will be excluded from the print.
Advertisement
Open your Excel worksheet. Double-click the worksheet or go to “File > Open” in Excel.
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.
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”.
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.- The “Orientation” button switches between landscape and portrait orientation.
- The “Margins” button adjusts the margins on a printed page.
- “Scale to Fit” chooses how many pages you want to fit your printed content into.
- You can clear, overwrite or add to the print area from the same dropdown menu.
Go to “File” and select “Print”. The menu is in the top left corner of your screen and brings up “Print Settings”.
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.- Note that “Print the selection” means that any newly highlighted selection overrides your designated print area.
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.
Advertisement
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.
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).
Go to the “File” menu and select “Print”. The menu is in the top left corner of your screen and brings up “Print Settings”.
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.
Adjust other print settings. Dropdown menus below the selection menu allow you to adjust layout options like page orientation or margins from this panel.- If you previously set a print area but decide against using it, select “Ignore Print Areas” to ignore.
Press "Print". The button is located at the top of the menu and your selected sheets will print, excluding the others.
Advertisement
Community Q&A
Search
- QuestionHow do I print on both sides of a single piece of paper?
Community AnswerGo to "File > Print". In the print settings, you can select to print one-sided or double sided from the dropdown menu. - QuestionHow do I print with a freeze?
Community AnswerGo to the Page Layout tab and select Print Titles. Select the "Sheet" tab and in the "Rows to repeat at top box" or the "Columns to repeat at left" box, enter the rows or columns that you want to appear on every page you print.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
SubmitAdvertisement
Video
Tips
- Once you've set the print area Print Preview will show you what you've selected to print.Thanks
- To Print the Whole document after setting the print area just select Page Layout -> Print Area -> Clear Print Area.Thanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
Advertisement
Warnings
- You can only set one Print Area at a time.Thanks
- If you set multiple areas of a worksheet, as one Print Area, you will get each area being printed on a separate paper.Thanks
Advertisement
Things You'll Need
- Microsoft Excel
- Printer, to print the document.
- Paper, to print on.
About This Article
How.com.vn Staff Writer
This article was co-authored by How.com.vn Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. How.com.vn's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards. This article has been viewed 326,061 times.
How helpful is this?
Co-authors: 19
Updated: June 26, 2023
Views: 326,061
Categories: Microsoft Excel
Thanks to all authors for creating a page that has been read 326,061 times.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
Advertisement
