Click here to get my tips every week

Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365


March 7, 2017

Greetings from The Excel Addict

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?

20170307 Newfoundland weather pic by Francis Hayes TheExcelAddict.com
Please feel free to share my newsletter with your Excel friends — they will thank you for it.

Hope you're having a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com





TheExcelAddict.com Quote of the Day

"No winter lasts forever;
no spring skips its turn."

-- Hal Borland --




If you missed my last newsletter, you can click here to view it online.



Excel in Seconds with TheExcelAddict.com

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.

Open File Location in Microsoft Excel 2007 2010 2013 2016 365





If you've found this tip helpful, please click here to share it.


Click here to get my tips every week


Thanks for supporting this newsletter and website

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630