Shortcuts

BY STANLEY ZAROWIN

Shortcuts

Word: To select a single word, double-click on it. To highlight a sentence, hold down Ctrl while you click once anywhere in the sentence. To select an entire paragraph, click three times (quickly) inside the paragraph.

Excel: A quick way to get to a remote cell: Press Ctrl+G and this screen at right will pop up.

Then type the cell location under Reference .

Word: A one-key way to highlight: Press F8 twice to highlight the word under the cursor, thrice to highlight the sentence, four times the paragraph and five times for the entire document. Option: Press F8+, (comma) to highlight the sentence; press F8 again to highlight the entire document.

   
   
Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to contributing editor Stanley Zarowin via e-mail at zarowin@mindspring.com .

Because of the volume of mail, we regret 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 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.

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.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: Economy and health care changes top CPAs’ list

CPA decision-makers’ economic outlook and the House Republicans’ proposed tax changes as part of replacing the Patient Protection and Affordable Care Act received attention recently. See how much you know with this short quiz.