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

2019 State of Financial Reporting Survey

We surveyed nearly 600 finance and accounting professionals on their month-end close and reporting processes. See the results.

VIDEO

What RPA is and how it works

Robotic process automation is like an Excel macro that can work on multiple applications, says Danielle Supkis Cheek, CPA. RPA can complete routine, repetitive tasks such as data entry, freeing up employee time from lower-level chores.