A Better Idea & Shortcuts

BY STANLEY ZAROWIN

A BETTER IDEA

In the January 2008 issue (page 81), I offered some suggestions for solving the My Document folder default-location problem, and Amanda Adams, CPA, tax manager at Blazek & Vetterling in Houston, suggested another solution for assuring that files are saved in a default location of your choosing. In Word, for example, go to Tools, Options, File Locations and change the default location (see screenshot below).

And in Excel, go to Tools, Options, General.

Also in the January 2008 issue (page 83), I described how a hotel room key card can become deactivated if it’s kept next to a cell phone. Several readers wrote to say key cards can cause problems, too. For example, if they are stored next to credit cards, they can deactivate the credit cards. One reader said it wiped out his Washington, D.C., Metro pass card.

SHORTCUTS

  • Add a date in Word: Alt+Shift+D
  • Add a date in Excel: Ctrl+;
  • Copy formatting in Word: Ctrl+Shift+C
  • Paste copied format in Word: Ctrl+Shift+V

SPONSORED REPORT

2019 State of Financial Reporting Survey

We surveyed nearly 600 finance and accounting professionals on their month-end close and reporting processes. See the results.

VIDEO

What RPA is and how it works

Robotic process automation is like an Excel macro that can work on multiple applications, says Danielle Supkis Cheek, CPA. RPA can complete routine, repetitive tasks such as data entry, freeing up employee time from lower-level chores.