In this article, you will learn how to change the default directory in Excel.
Change the Default Directory
Excel, by default, saves all files in the folder: C:\Users\*username*\Documents. To change this, in the Ribbon, go to File > Options.
1. In the Excel Options screen, choose Save.
2. Then change the Default local file location (under Save Workbooks) to the desired directory.
Now, Excel files will, by default, be saved in the new folder that you specified in Excel Options.