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.
– After selecting the area you want to print out, go to Page layout > Print Area > Set Print Area.
– Click the Print Titles button in the Page Setup section of the ribbon.
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.
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.