Cell selections reach new heights

BY J. CARLTON COLLINS, CPA

Q: In Excel, is there a way to click on a cell containing a hyperlink without triggering the hyperlink? (Surely my current method of clicking next to the cell and then using arrow keys cannot be the best method.)

A: Make the row height bigger or the column wider, then you can click in the white area of the cell to select it without triggering the hyperlink.

 

SPONSORED REPORT

Time to prepare for overtime changes

As an employer, trusted business adviser, or HR professional, you will need to be aware of exemption guidance, record requirements, advice for clients, and typical problems in applying overtime pay.

QUIZ

News quiz: Good news on pay and benefits for accountants

CPAs can find much to like in recent reports, including news that their expertise and skills are in such demand that pay is expected to rise and that their employers value professional certifications.

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.