Select A Customized Worksheet With A Mouse Click

BY STANLEY ZAROWIN

SELECT A CUSTOMIZED WORKSHEET WITH A MOUSE CLICK 
I need to use 12 different Excel file setups—each loaded with ifferent formulas and formats. And each month I have to create a new blank file formatted to match one of those 12, which is a pain. My alternative method is to copy one of the old worksheets and then just remove the data. But either way, it takes time. Do you have a better way to do this?

 The easiest solution I can think of is very low-tech. I would just create a template of a single file that contains 12 worksheets—each custom-designed to match one of the 12 you need. You then can store that file so you can evoke any of the custom designs with just two sets of mouse clicks—one to launch the template and the other to open the custom worksheet. When you launch the template and select the worksheet, just save it as a file and you’re ready to start work on it.

However, to keep the process simple—to avoid having to search for the template—I’d suggest you make one small adjustment when you’re ready to save the 12-workbook template. After you click on Save as and give it a descriptive name and then cursor down to Template (*.xlt) , don’t let Excel save it to the default template folder. Instead, save it to some other convenient folder—such as the one where you typically save your working spreadsheets (see screenshot below).

Then go to your desktop and click on New , Shortcut . When the Create Shortcut screen appears, browse to that convenient folder where the template is situated, locate the template file, highlight it and click on OK.

Once it’s set up, right-click on it and change the name to something short and descriptive and then click on Properties , where you can select a descriptive icon.

Now the custom spreadsheets are right at your fingertips.

Bonus: You can create a family of customized Word files the same way. If, for example, you want to store a collection of frequently used letters or memos, place one on successive pages of the file. Now all the form letters are accessible on the desktop under one icon.

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.