How to Print Only Selected Areas of a Spreadsheet in Excel 2007 & 2010


If you have a huge spreadsheet in Excel, printing all of it can be a waste of paper and ink. Instead, if you only want some parts of the sheet to be printed, this article will show you how to print only specific areas of the spreadsheet in Excel.

1.      Select your specific data. Hold down the Ctrl key while highlighting.

Figure 1: We select some data from the worksheet.

2.      Go to Page Layout and select Print Area > Set Print Area.

Figure 2: Click on Set Print Area.

3.      Also, if you select Print Tiles from the Page Layout tab, you can specify which column gets repeated.

Figure 3: Customize your print area.

4.      Click Print Preview to see what your data will look like on paper.

Figure 4: The Print Preview of your Excel data.

5.      You can also add other sections from the worksheet by selecting them and clicking on Add to Print Area.

Figure 5: Adding some other sections to the print area.

6.      If you click next page on the Print Preview, you will see your added data.

Figure 6: You will see that the area has been added in Print Preview.

7.      You can also select Clear Print Area to erase the print areas you don’t need anymore.

Figure 7: Clear the Print Area.

In Excel 2010, the process is relatively the same, except that Backstage View opens and you can adjust your printing preferences there.

This is yet another way of keeping your Excel data organized and not wasting too many trees by printing a lot.

 

 

Latest Articles

How to Use Sparklines in Excel 2010

// Excel 2010 has a cool feature called Sparklines, which is like a small chart displayed next to your tabular … Continue reading

How to Share Access Data with Excel in Office 2010

One of the great benefits of Office 2010 is the ability to share Access Data in Microsoft Excel. In this … Continue reading

How to Use Templates in MS Office 2010 and 2007

Templates are the handiest thing when it comes to rush documents and presentations. They are also the most convenient since … Continue reading

How to Use Conditional Formatting to Find Duplicate Data in Excel 2007

Suppose you have a worksheet in Excel that contains duplicate data. You might want to highlight these but you don’t … Continue reading

How to Set Office 2007 Color Scheme with a Quick Registry Hack

Using the GUI (as written in a previous article) for changing the Office 2007 color scheme is quite easy, but … Continue reading

How to Save and Restore Microsoft Office Settings

Have you ever wanted to save your perfectly-tweaked settings (which you have probably spent ages to do) and you are … Continue reading

How to Print Only Selected Areas of a Spreadsheet in Excel 2007 & 2010

If you have a huge spreadsheet in Excel, printing all of it can be a waste of paper and ink. … Continue reading

How to See the About Dialog and Version Information in Office 2007

With the Ribbon system and completely different menus in Office 2007, most users probably don’t know where to look for … Continue reading

How to Print Out or Export Directory Lists to MS Word & Excel

Have you ever been tasked to present or print out your directory list in MS Word? Rather than browsing each … Continue reading

How to Make Excel 2007 Wrap Text in Cells

In an instance you have data in your cells that are too long to display that it extends to the … Continue reading