This tutorial provides the steps required for changing the default file location in Excel 2011 for Mac. Users can set their preferred file location using the Excel Preferences.
Click the Excel menu and select Preferences from the menu list. Click the General option available under Authoring section.
In the General Preferences window, navigate to Preferred file location and click the Select button.
The default file location in Excel 2011 is set to the Documents folder. You can change location to your preferred folder using the below window.
Let us say you want to save all your excel files under Excel Work folder, then create a folder and click the Choose button.
Now click Ok button on the General Preferences to confirm and save the changes.