Excel: To toggle between displaying data and formulas, press Ctrl+~ (tilde).

Word and Excel: To cycle through all open documents or worksheets, press Ctrl+F6.

Word: To remove any added formatting to text, highlight the characters and press Ctrl+Space Bar or Ctrl+Shift+Z.

Word: To double underline text, highlight the characters and press Ctrl+Shift+D.

Word: To repeat the last word, phrase or other passage of text you just typed, move your cursor to the place you want it copied and press F4. The key must be used before you use any other Word command or type any other text.

Stanley Zarowin, a former JofA senior editor, is now a contributing editor to the magazine. His e-mail address is .

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to me via e-mail at or via regular mail at the Journal of Accountancy, 220 Leigh Farm Road, Durham, NC 27707-8110.

Because of the volume of mail, I regret I cannot individually answer submitted questions. However, if a reader’s question has broad interest, I will answer it in a forthcoming Technology Q&A column.


©2008 AICPA


Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.


News quiz: Retirement planning, tax practice, and fraud risk

Recent reports focused on a survey that gauges the worries about retirement among CPA financial planners’ clients, a suit that affects tax practitioners, and a guide that offers advice on fraud risk. See how much you know with this short quiz.


Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.