Microsoft encourages users to save their work in OneDrive by making it the default save location in Office 2013. This is handy if you regularly use OneDrive to backup and sync your files, but for those who use online services, or those who prefer to save their files locally, it’s annoying and inefficient to have to deselect OneDrive each time you try to save a file, and instead manually navigate to your save location of choice. Thankfully, this problem can be easily solved by setting a new default save location in Office 2013 settings. Note that the steps described here are unique to each major Office app, so you’ll need to repeat these steps in Word, Excel, and PowerPoint if you want all three apps to save to the same new default location.
How you can export Excel to PDF on the Mac and the Windows? Advanced OCR tool allows you to convert and edit scanned PDF files in a few simple steps. Method 3: Export Excel to PDF Using Excel for Windows. There are multiple version of the MS Excel software available for the Windows. If you want to use keystrokes Ctrl + Shift + DownArrow to highlight contiguous cells in Excel in Parallels, Go to the Parallels Desktop menu > Preferences > Shortcuts tab > System Shortcuts > set 'Send System Shortcuts' option to 'Always'.
However, by maintaining separate settings for each app, it makes it easy to set different default save locations depending on your workflow; for example, saving all Word documents to your local user documents folder, and saving all Excel files to a network location shared with the Accounting department. For our screenshots, we’re using Word 2013, but the steps are the same for Excel and PowerPoint. First, launch your Office 2013 app and open an existing document, or create a new document. With the document open and viewable, find and click File in the top-left portion of the window. This will launch what Microsoft calls the Office ““, which lets you open existing documents, create new documents, and access important feature such as print and export settings. Locate the Options button at the bottom of the list on the left.
In the Options window, select Save from the list of options on the left. This reveals a number of save-related settings and preferences. To remove OneDrive as the default save location, find and check the box labeled Save to Computer by Default.
This will tell Word, Excel, or PowerPoint that you want your documents to be saved to your computer, or a network-attached volume, instead of an online service like OneDrive. The default save location is your user Documents folder. If the user Documents folder works for you, then you’re all set. If, however, you’d prefer to set a custom save location, click the Browse button next to the Default Local File Location box and navigate to the desired location on your PC. When you’ve made your selection, click OK to save it, and OK again to close the Options window. You’ll now need to quit and restart Word, Excel, or PowerPoint in order for the change to take effect, so manually save any open documents and close your Office apps.
After reopening Word, Excel, or PowerPoint, any new save commands will select the location on your PC that you identified in the Options window by default. Of course, you can still save to OneDrive or any other location on your PC, but you’ll need to manually navigate to these locations in the Office Save window. Therefore, to maximize efficiency, make sure you set your most-used save location in Office 2013 settings, ensuring that, most of the time, all you have to do is click “Save” to place your document in its intended location.
Want news and tips from TekRevue delivered directly to your inbox? Sign up for the TekRevue Weekly Digest using the box below.
![How to go to advanced setting in excel for mac free How to go to advanced setting in excel for mac free](/uploads/1/2/5/6/125627362/848651525.png)
Get tips, reviews, news, and giveaways reserved exclusively for subscribers.
Familiar way to open Excel Options if you have If have installed Classic Menu for Office on your computer, you will discover that the classic style drop down menus and toolbar come back into Ribbon under Menus. So you can follow your use habit in Excel 2003 to seek for Excel Options in Microsoft Excel 2007/2010/2013:. Click the Tools drop down menu under Menus tab;. Then you will view the Excel Options item. Click it, and you will enter into Excel Options window. Figure 1: Open Excel Options window from Classic Menu Open Excel Options from Excel 2007 Ribbon if you do not have. Click the Office button at the upper-left corner;.
At the bottom, you will view the Excel Options button. Click it into Excel Options Window. Figure 2: Excel Options button in Excel 2007 Ribbon Open Excel Options from Excel 2010/2013/2016/2019 Ribbon if you do not have. Click the File tab jumping into backstage view;. Then you will view the Options button at left bar. Click it into Excel Options window.
Figure 3: Open Excel Options window from Excel 2010 Ribbon There is another way to find out the Options button in the backstage view:. Click the File tab;.
Click the Help button at left bar;. In the middle pane, you will view the Options button under the Tools for Working With Office. More Tips for Microsoft Excel 2007, 2010, 2013, 2016 and 2019. Classic Menu for Office Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013 and 2016. You can use Office 2007/2010/2013/2016 immediately without any training. Supports all languages, and all new commands of 2007, 2010, 2013 and 2016 have been added into the classic interface. It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013 and 2016.
![Setting Setting](/uploads/1/2/5/6/125627362/530339896.png)
It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007. Screen Shot of Classic Menu for Excel.