98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hyperlinks
Hyperlinks
Resolved · High Priority · Version 2010
Wed 17 Aug 2011, 16:35Delegate Sonia said...
Sonia has attended:
Excel Intermediate course
Hyperlinks
I can add 10 hyperlinks from one file to different cells at any one time. Does anyone know how I can bookmark the folders so that every time I insert a new hyperlink it goes back to the last place i.e. the last file, so I don't have to keep opening the same folders to get back to the folder contacting the required files.
Fri 19 Aug 2011, 10:51Trainer Jacob said...
RE: Hyperlinks
Hi Sonia
Thanks for your post.
I am checking this with a few colleagues to see if we can find a way that will help you here.
I too insert hyperlinks in Excel and I usually find that Excel will look in the same folder where my spreadsheet is saved.
If you are using the same spreadsheet you may want to save your links in the same folder.
Regards
Jacob
Mon 22 Aug 2011, 11:40Trainer Anthony said...
RE: Hyperlinks
Hi folks. In Excel 2010 click the File tab, then the Info option. On the right of the screen click "Show All Properties". A list of fields will be revealed, one of which is "Hyperlink Base". Try clicking in there, adding the folder path you want your hyperlinks to default to and see if that does that trick.
Hope this helps,
Anthony
Wed 24 Aug 2011, 10:28Delegate Sonia said...
RE: Hyperlinks
Hi Anthony,
Thanks for your suggestion.
I've had a go adding in a folder path but it doesn't seem to make any difference when I try to add a new hyperlink to the document.
What I really want it to do is remember the last folder I opened when adding a new hyperlink so I don't have to keep opening x amount of folders to find the same folder over and over again.
Is this possible?
Sonia
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting constant values onlyIf periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter. |
