Excel has several different templates that can be used in creating an Excel document. Sometimes, you may only use one template most of the time. Secondly, you may always work on the same document most of the time. Therefore, you may be forced to open the same document every time you are working on the document. Thankfully, Excel allows users to set a default startup document. In this tutorial, we shall discuss ways of opening Excel documents automatically.
To automatically open a specific Workbook
Follow these steps to achieve this:
1. Open the Excel application.
2. Click on the File tab on the Ribbon.
3. From the File menu, click on the Options Button. Then, click on the Trust Center button in the Word Options dialogue box.
4. Click on the Trust Center Setting button from the Trust Centre pane.
5. In the Trust center dialogue-box screen, click the Trust Locations button in the left pane.
6. Double-click on the Excel Startup section to open the Trusted Location dialogue box.
7. In the dialogue box, highlight the path in this section and copy it. To copy the path, press CTRL + C on your keyboard.
8. Open any folder on your PC and paste the copied path. Then, hit the Enter button.
9. The startup Excel folder will open. Add the Excel file you want to open automatically in this section. The added Excel file will open automatically the next time you open the Excel application.
To open Blank File on startup
A Blank file is an Excel file that has empty cells. Below are the steps to set a Blank file as a startup:
1. Open the Excel application.
2. Click on the File tab on the Ribbon.
3. From the File menu, click on the Options Button. Then, click on the General button in the Word Options dialogue box.
4. Scroll downwards and locate the Startup Options section.
5. In this section, uncheck the Show the start screen when this application starts checkbox.
6. Then, click the OK button to close and save changes.
To automatically open Workbooks in a specific folder
Here are the steps to follow:
1. Open the folder that contains the Excel files you want to open automatically in Excel.
2. Click on the path of the folder and copy it. To copy the path, press the CTRL + C keys.
3. Open the Excel application.
4. Click on the File tab on the Ribbon.
5. From the File menu, click on the Options Button. Then, click on the Advanced button in the Word Options dialogue box.
6. Scroll downwards and locate the General section.
7. Under the General section, locate the "At startup, open all files in:" section.
8. Paste the copied path in this section. To paste the path, press your keyboard's CTRL + V keys.
9. Finally, click the OK button; that is all you need to do.