Shortcuts

BY STANLEY ZAROWIN

In Excel, to create a chart using the current selected range, press F11 or Alt+F1.

In Excel, to insert today’s date, press Ctrl + ; (that’s the Ctrl button and a semicolon).

In Excel, to view all the formulas in a workbook, press Ctrl+~;. For some reason you don’t have to hold down the Shift key (since the ~ button is above the ` (accent) button). Press Ctrl+~ again to return to normal.

In Word, to show all the formatting marks, press Ctrl+Shift+* (that’s the asterisk mark above the 8 button (in this case you do have to press the Shift key). Toggle (press Ctrl+Shift+*) to hide them.

In Outlook, you can keep separate windows open for each folder (that is, Calendar, Inbox, Tasks). To open a separate window, simply right-click on the item under Folder List and then select Open in new window .

Do you have a technology question for this column? Send it to Senior Editor Stanley Zarowin via e-mail at zarowin@mindspring.com or regular mail at the Journal of Accountancy, Harborside Financial Center, 201 Plaza Three, Jersey City, NJ 07311-3881. We regret that we cannot answer letters individually. If a reader’s question is deemed to have sufficiently broad interest, we will answer it in a forthcoming Technology Q&A column.

—The editors

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.