February 14, 2017
Hi fellow Excel Addict,
Happy 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.
Sharing my newsletter
I 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)
If you missed my last newsletter, you can click here to view it online.
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.
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
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.
Alternate methods will work too
You can also type or paste %APPDATA%\Microsoft\Excel\XLSTART
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.
| '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