Shortcuts

BY STANLEY ZAROWIN

For Excel

  • Ctrl+Shift+!—Applies the number format with two decimal places, thousands separator and minus sign ( - ) for negative values.
  • Ctrl+Shift+$—Applies the currency format with two decimal places (negative numbers in parentheses).
  • Ctrl+Shift+%—Applies the percentage format with no decimal places.
  • Ctrl+Shift+#—Applies the date format with the day, month and year.

 

For Word

  • When replacing text with new text, you don’t have to use the Delete key. Instead, select the old text, and as you start to type, the old text will vanish.
  • A quick way to toggle Print Preview: press Alt+Ctrl+I. Press it again (or Esc) to return to normal view.
  • If you type something and then change your mind, press Ctrl+Backspace to delete a word at a time. And if you get overzealous, press Ctrl+Z to bring it all back.

 

For Windows

  • Best time to defrag: right after a restart. This allows the operating system to clear out files in memory and lets the defrag tool focus on the hard disk data.

 

SPONSORED REPORT

6 key areas of change for accountants and auditors

New accounting standards on revenue recognition, leases, and credit losses present implementation challenges. This independently-written report identifies the hurdles that accounting professionals face and provides tips for overcoming the challenges.

PODCAST

How tax reform will impact individual taxpayers

Amy Wang, a CPA who is a senior technical manager for tax advocacy at the AICPA, answers to some of the most common questions on how the new tax reform law will impact individual taxpayers.