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

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.