March 7, 2017
Hi fellow Excel Addict,
In today's 'Excel in Seconds' tip, I'm going to show you how to 'Jump to The Current Workbook's Folder' right from within Excel.
If you missed my last 'Excel in Minutes' tip from Thursday, in it I showed you how simple it is to 'Create Your Own Custom AutoFill Lists'. You can read that tip here.
We are just a couple of weeks away from 'official Spring' but likely a couple of months away from 'actual Spring' here in Newfoundland. But there is a glimmer of hope. Look what I spotted behind my house today?
Hope you're having a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
Quickly Jump to The Current Workbook's Folder
If you're like me and use Hyperlinks to open frequently-used workbooks, you may find that often you don't remember where the workbook is actually saved. And sometimes you may need to go to the folder where the workbook is saved.
Just click the File tab and the Info screen opens. You will see an 'Open File Location' option in the bottom right corner. Click it and you will instantly be taken to the current workbook's folder in File Explorer.
If instead of going to the folder you just want to see its path, hover your mouse pointer over the 'Open File Location' option for a second or two and the path will pop up.
If you need to copy the path to the clipboard so you can paste it elsewhere, right click the Open File Location option and choose Copy Path.
If you've found this tip helpful, please click here to share it.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630