Still Waters Run Deep Yeah, we haven’t had a post here since October. But that doesn’t mean things haven’t been going on! We started as a blog – in 2009! – and I suspect that many longtime followers still think…
Hyperlinks Are a MUCH Better than Making the User Find the Right Sheet Tab
Sorry About Last Week
Yeah, we were a bit “light” on new material here on the blog last week. That happens when I have four straight days of presentations out of town (more on PASS BACON later).
Inspired by Kasper’s Book!
I was reading Kasper’s new book on the plane (yes, I was home less than 24 hours, and am now back on the road), and its singular focus on building a full-featured set of dashboards inspired me.
It is clearly time for a mega-post on hyperlinks!
First Usage: a Menu Sheet
As pictured at the top of this post, hyperlinks are a great way to construct a “menu” sheet.
Not only is this a BIG convenience for the “consumers” of your workbooks, but it makes the whole thing “feel” much better too. More professional, more like an application and less like a spreadsheet.
Yes, hyperlinks can link to other locations in the workbook! It’s easy in the Insert Hyperlink dialog: