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

February 14, 2017

Greetings from The Excel Addict
Microsoft Excel 2003, 2007, 2010, 2013 Tips
Hi fellow Excel Addict,

Francis Hayes ( Valentine's Day from stormy Newfoundland, Canada. I may be giving you the impression that we are constantly being bombarded by snowstorms here all winter long but that's not the case. I just don't tell you about all of the boring, half-decent weather we get throughout the winter. This past week has been pretty tame with even a few sunny days. In fact, this past Saturday I did a 12KM run in the sunshine on bare pavement.

But today we are getting walloped by a fierce winter snowstorm that has been making its way across North America over the past week. Everything is shut down here in eastern Newfoundland today, so it's a great day to stay inside in the warmth and rest up for all the snow shoveling that's on the menu for tomorrow.

In today's 'Excel in Seconds' tip, I'm following up last weeks XLSTART tip by showing you how to 'Take a Shortcut to Your XLSTART Folder'.

If you missed my 'Excel in Minutes' tip last Thursday, 'Remove Duplicate Values From Your Data in Seconds', you can read it here now.

New Free Webinar from Mynda
Watch your email tomorrow for some exciting news I will be sharing about a new free webinar that Mynda will be giving. This will take your Excel reporting to the stratosphere.

Power BI Webinar by Mynda Treacy

Sharing my newsletter
Share 'Spreadsheet Tips From An Excel Addict' with your friendsI don't know if you've noticed but I've recently added some 'sharing' buttons below. They may not show up in the email version of this newsletter but if you click the 'click here to share it' link below you will see the buttons online. Please help me spread my Excel addiction by sharing with your friends and colleagues. I really do appreciate it.

Hope you're having a great week and keep on Excelling,
Francis Hayes (The Excel Addict)

Francis Hayes ( Quote of the Day

"The opposite of love isn't hate; it's indifference"

-- Steven Pressfield, The War of Art --

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

Excel in Seconds with

Take a Shortcut to Your XLSTART Folder

In last Tuesday's 'Excel in Seconds' tip I showed you how to use the XLSTART folder to open a specific workbook when Excel starts.

If you record macros in your Personal Macro Workbook, that too is stored in the XLSTART folder.

So there may be several reasons why you would need to access your XLSTART folder. But if you're like most Excel users, you probably don't know where to find it.

The reason it is so hard to find is that the XLSTART folder is located in a subdirectory of the AppData folder which is a hidden system folder.

Here's what I've done to make it easy to get to my XLSTART folder without having to remember its location. I have created a shortcut to it on my Desktop. If you frequently, or even occasionally, need to access your XLSTART folder, try this...

Take a shortcut to your XLSTART folder
1) Right-click on your Desktop and choose New, Shortcut;
2) In the 'Type the location of the item' field type or paste the following...


3)  Click OK.

You are now just a click away from your XLSTART folder even if you don't remember where it is.

Desktop Shortcut To Xlstart Folder in Microsoft Excel 2007 2010 2013 2016 365

Make your XLSTART folder visible:
As I said before, your XLSTART folder is located within the hidden AppData system folder. If you want, you can make the AppData folder visible by changing an option in File Explorer.

1) In File Explorer (formerly Windows Explorer), on the View tab click the Options button;
2) On the Folder Options dialog, click the View tab;
3) In the Advanced Settings section, find the 'Show hidden files, folders and drives' and select it;
4) Click OK to close the Folder Options dialog

Show Appdata Folder in Microsoft Excel 2007 2010 2013 2016 365
If you don't see the AppData folder right away within your 'USERNAME folder, close and reopen File Explorer. Then click on AppData and navigate down through the Roaming, Microsoft, and Excel folders, you should see the XLSTART folder.

File Explorer Path To Xlstart in Microsoft Excel 2007 2010 2013 2016 365

Alternate methods will work too

You can also type or paste
into File Explorer's address bar or in Excel's Open dialog to jump to the XLSTART folder.

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

Click here to get more tips like this 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
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630