Excel: A quick way to copy the number in a cell that is immediately above the cell you’re in: Press Ctrl+” (that’s Ctrl plus the quote mark, which means you have to hold down the Shift key as well). That also copies the number’s formatting.


Word: To format (bold, underline, italicize, etc.) many different words scattered throughout a document, hold down the Ctrl key and highlight each word. Then, when you apply the formatting, all the highlighted words will be identically formatted. It works in all editions of Word.


Office 2003: To move a toolbar button in any of the Office apps, hold down the Alt key and drag the button to the new location.


More from the JofA:


 Find us on Facebook      Follow us on Twitter



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.


News quiz: Retirement planning, tax practice, and fraud risk

Recent reports focused on a survey that gauges the worries about retirement among CPA financial planners’ clients, a suit that affects tax practitioners, and a guide that offers advice on fraud risk. See how much you know with this short quiz.


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.