Fast Way To Select Print Area In Excel

BY STANLEY ZAROWIN

Q. I regularly print many different sections of a large and complex spreadsheet. Since I don’t want to print the entire workbook, I must highlight the area to be printed and then, when I evoke the print menu, I click on Selection so that only the highlighted area is printed. As you can imagine, when you have many sections to print, it becomes tedious. Any suggestions?

A. I have two. First, highlight the area to be printed and click on File, Print Area , and then lock in the section you want printed by clicking on Set Print Area . When you evoke the print command, only that section will print. Of course, when you want to print a different area, you must go back to Print Area and click on Clear the Print Area . While that won’t save you much time, it will at least ensure you capture the right area.

To really save time, use Excel’s Name function to create a kind of catalog of areas that you repeatedly print. To do that, block the first area you want to print and highlight it. Then move your cursor up to the Name box, which is in the upper left corner of the worksheet, in this case labeled A1 because the cursor is in A1.

Type in a descriptive name for that highlighted area, replacing A1. I will name it Profit/Loss . Then, one after the other, highlight all the other areas in the worksheet and give each its own descriptive name.

When you’re ready to print, click on the Name box and search for the area you want to print. When it appears click on Selection and then Print .

 

That should speed up your selective printing operation.

 

An amplification

Many readers alerted me that one of my solutions to a question in the March column, while workable if you had enough stamina, was hardly the best way to solve the problem. A reader had sought a way to change his user ID, an identification that is automatically inserted when adding comments in Excel or Word. Several other readers wrote in to suggest a better way, which requires little more than a few mouse clicks. In Word, go to Tools, Options , and click on the User Information tag. Then just type the new name.

In Excel, go to Tools, Options, and after you click on the General tab, fill in the new name. What could be easier?

 

 

SPONSORED REPORT

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

QUIZ

News quiz: Scam email plagues tax professionals—again

Even as the IRS reported on success in reducing tax return identity theft in the 2016 season, the Service also warned tax professionals about yet another email phishing scam. See how much you know about recent news with this short quiz.