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

Excel: If you have multiple spreadsheet workbooks open, you can quickly switch between windows without the mouse by pressing Ctrl+F6. This will cycle you between open workbooks.

Outlook calendar: You can color code important engagements on your calendar by right-clicking on an appointment and then clicking on Labels in the dropdown menu, selecting the color of your choice.

Web site identification: To quickly determine the source of an Internet site, either go to and enter the URL there, or while at the site with Internet Explorer, click on Tools and Show Related Links.

Excel: A quick way to delete cells: Pressing Ctrl+- (the minus key, either on the regular keyboard or the numeric keypad) launches the Delete dialog box, saving you some mouse clicks.

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to Senior Editor Stanley Zarowin via e-mail at .

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

On occasion you may find that you cannot implement a function I describe in this column. More often than not it’s because not all functions work in every operating system or application. I try to test everything in the 2000 and XP editions of Windows and Office. It’s virtually impossible to test them in all editions and it’s equally difficult to find out which editions are incompatible with a function. I apologize for the inconvenience.


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.


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.