I’ve discussed in the past how you could use Excel to add links to many different files on your computer that you use on a daily basis in order to become more productive. I got a similar question that might be of help to you. Basically, let’s imagine this user has a frontpage with several informations that are all displayed on different tabs. The summary is a recap but all details would be found in the many other tabs of the excel file. Here is a summary of a simplified version:
The names refer to different tabs as you can see:
Basically, I could go on the cells and either do “Insert/Hyperlink” or click “Ctrl-K”, the shortcut:
Then, I would simply select on the left that I’m looking to link to a “place in this document” on the left menu, cell A1 (which could be changed):
Once that is done, the user can click on that cell and be automatically taken to the correct location to see a breakdown of what that number means
It’s easy to do and can turn out to be a time saver for both yourself and others that are using the excel spreadsheet! Makes sense?
***************************************************
Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss
***************************************************
Immigration Advice folkstone
I got this web site from my buddy who told me concerning
this website and at the moment this time I am browsing this
web site and reading very informative posts at this place.
MOHAMADREZA
THANKS
RESPECTLY
MOHAMADREZA FROM IRAN