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

Click-through nexus: Pushing the boundaries of sales tax compliance

Sales and use tax compliance has been complicated by nexus expansion. In this report, we provide an overview of this issue and include a handy state-by-state summary of click-through nexus or notification requirements.

QUIZ

News quiz: Making allowances for the kids and the economy

Recent news gives CPAs insight into Americans’ attitudes about children and money and gauges outlook on the economy. See how much you know about recent news and reports with this quiz.

CHECKLIST

Auditing risks in culture

Cultural flaws can seriously damage an organization. Here’s how internal auditors can reduce risks by embedding culture audits into existing audit programs.