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

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out