How To Print Only A Selected Area Of An Excel Spreadsheet



How To Print Only A Selected Area Of An Excel Spreadsheet
An  Excel spreadsheet can have a thousand rows and a thousand columns. It’s almost impossible to manage printing a large Excel spreadsheet.

At the office or home office, there will be many times when you need to print out Excel spreadsheets. But often times you really don’t need to print out the entire report which wastes paper, ink, and time. What if you need to include the cells in a spreadsheet but not its graphs? Or perhaps you only need to include a more specific range of cells in the printed output? Here’s how to print out only the specific areas of the spreadsheet that you need.

I have an excel speed sheet with information about prices. This excel spread sheet contains lots of data that will not need to be printed. I’ll show you how you can choose rows or columns to appear on every page when you print.

How To Set Print Area In Excel

– Start by opening the Excel spreadsheet
– Ctrl key and highlight the area of the document you want to print out.

How To Print Only A Selected Area Of An Excel Spreadsheet

– Go to the Page Layout tab.

– After selecting the area you want to print out, go to Page layout > Print Area > Set Print Area.

How To Print Only A Selected Area Of An Excel Spreadsheet

–  Click the Print Titles button in the Page Setup section of the ribbon.

How To Print Only A Selected Area Of An Excel Spreadsheet

Next select the Sheet tab in the Page Setup windows that appears. From here type in the Columns and Rows that you want to repeat (if any) then click on Print Preview. This allows you to include any headers or labels associated with the data.

You can also save ink by configuring Excel’s Fit to scaling option on the Page Setup window to fit all printed spreadsheet content on one page only.

How To Print Only A Selected Area Of An Excel Spreadsheet

You can redefine the print area as many times as you want though it’s worth mentioning that if the print area is large, you will still have the rows and columns overflowing on to other pages when printed. This is a solution that works when you need to take a quick print. To reset the print area, simply select the ‘Clear Print Area’ option from the same drop-down as shown in the screenshot above.

Recommended For You

How To Only Print An Area İn Microsoft Excel

How to Fix a Missing Excel or Word icon on the Desktop

How To Copy And Paste Performance Information In Windows 10

How to Access the Developer Tab in Excel

How to Working with Currencies in Excel

How To Copy And Paste Performance Information In Windows 10

Which Version of Microsoft Office Do I Have (32/64 bit)

Published on: Jan 1, 2018 – edited dateÇ 04-04-2020

Add a Comment

Your email address will not be published. Required fields are marked *