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

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