I have an Excel spreadsheet that I use to track my investments, and I’d like to print it to take to my tax guy. I don’t want to print the whole thing, though—I need to find some way to just print a portion of the spreadsheet. I don’t see an option to do this when I select the Print menu item. What’s the trick?
Excel uses a feature called print area to control what gets printed. When you use the print menu, first select the area you like to be printed this can be a single rectangular area or if you're fancy multiple rectangular areas, then from the File menu choose the print area option, and then select set print area.
That's it you're done now.
When you choose the print menu item you'll see that just the area you've selected available to print if you try to print a spreadsheet but it only prints a subset of the data it's most likely because you or someone else has used the set print area menu item to restrict printing. In that case to clear the set print area, choose the file menu, then print area, then clear print area. That way you can again print the entire spreadsheet.
It's a simple tip but it allows you to print a subset of an Excel spreadsheet.