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

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

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

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.