Hyperlinks Article

Back in the old days, when I used workpapers that were made with, you know, paper, I used a red pencil to create cross-references that made it easy to navigate to related documents. Today, I use Excel hyperlinks instead. Check out this CalCPA Technology and Business Resource Guide article where I describe how to use Excel hyperlinks to cross-reference digital files.

http://www.excel-university.com/articles/cal-cpa/link-it/

 

Posted in

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Excel is not what it used to be.

You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.

Want to learn Excel?

Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.

1 Comment

  1. Bronson Quon on June 2, 2016 at 9:30 pm

    As a former auditor working in voluminous workpapers, I know what you mean with the red pencils and countless references. I enjoyed your detailed hyperlink instruction. I use them quite a bit now in large excel workbooks when there are multiple sheets and lots of data. I also like to “define names” for specific rows/columns to hyperlink directly to those locations. The fastest way from point A to point B is the most direct line!

Leave a Comment





For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.