Shortcuts


Shortcuts
Excel: A fast way to delete a cell—not the contents of a cell but the cell itself: Highlight the cell and press Ctrl+- (minus sign). The cell will disappear, and you will be offered options on which adjacent cells will shift to fill the empty space.

Word: To create an em dash (—), which is a long dash, press Ctrl+Alt+- (the minus key on the numeric keypad). However, beginning with the 1995 edition, Word will do that automatically if, after typing the last letter of one word you type two dashes in a row and then type the first letter of the next word.

Excel: Two quick ways to select a range of cells: Click in the first cell and then hold down the Shift key while you use the arrow keys to select the range. Or click in the first cell, press Shift and click in the last cell of the range.

Excel: To translate Arabic to Roman numerals, use this formula: =ROMAN (Arabic number) . So 1999 becomes MCMXCIX and 2003 becomes MMIII.

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 zarowin@mindspring.com .

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.

SPONSORED REPORT

Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.

QUIZ

News quiz: IRS warning on cyberattacks and a change in pension rules

Once again, the IRS sounds the alarm about a threat from cyberthieves. See how much you know about this and other recent news with this short quiz.

CHECKLIST

Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.