When you first launch Excel is there a file that you always open first before doing anything else? Do you get frustrated that you have to go through all the clicks to do so. (I know not that many but still frustrating!) Well, you probably did not know that you can make Excel open with that file automatically. In fact, you can have several files open automatically when you start Excel in the mornings.
Things to set up first
- You need to create a folder to place the file or files that you need opening every time you launch Excel.
Here is an example 
- Copy the full address of this folder to your clipboard.
- Move the file or files that you require to always open on launch to this folder.
How to set up files to open on launch
- Select File tab.
- Select Options at the bottom of the list.
- From the list on the left-hand side select Advanced.
- Scroll down to the section headed [General].
- In the long area to the right of [At startup, open all files in:] past the address line you copied earlier.
You are all set to go.
- Exit excel if you have not already.
- Click on the Excel icon and breath a cheerful sigh of contentment as you see your file or files appear as if by magic.
- When things change and you need more files to open, just move those files into this folder or move some out that you do not require to open a launch anymore.
N.B.
The files placed in the startup folder may well have a setting of “read only”, so you will need to go to the folder properties and change that if you have the access permissions. If not ask your IT tech team to change the setting to allow you full control of these files.
Another tiny step (That’s one small step for man) that makes a lot of difference to your day (one giant leap for mankind).
More tips for your perusal
