Excel includes a feature that allows you to quickly apply some basic formatting to inserted rows, columns, or cells in your worksheet. When you insert any of these items, a small, floating button, called “Insert Options”, displays next to the inserted row, column, or cell. This “Insert Options” button has a small paintbrush on it. When you click the button, Excel displays options for quickly formatting the inserted row, column, or cell. This can be handy at times, but the button might also be annoying.
![How To Get To Options In Excel For Mac How To Get To Options In Excel For Mac](http://whatafan.club/wp-content/uploads/2018/06/display-developer-tab-in-excel-show-developer-tab-in-excel-excel-developer-tab-excel-options-panel-with-the-customize-ribbon-checkbox-show-developer-tab-in-excel-display-developer-tab-excel-mac.jpg)
However, it’s easy to turn it off. To turn off the “Insert Options” button, click the “File” tab. On the backstage screen, click “Options” in the list of items on the left.
On the “Excel Options” dialog box, click “Advanced” in the list of items on the left. Scroll down to the “Cut, copy, and paste” section on the right and select the “Show Insert Options buttons” check box so there is NO check mark in the box. Click “OK” to accept the change and close the “Excel Options” dialog box.
By Geetesh Bajaj, James Gordon. Although it’s true that you can gain a better knowledge of any application if you visit its preferences and try to figure them out, it’s almost essential for Excel for Mac.
When you turn off the “Insert Options” button, you can still format the inserted row, column, or cell. Simply, select the row, column, or cell and right-click on it. A mini toolbar displays along with a popup menu. Use the mini toolbar to apply basic formatting to the item and perform other actions on the item using the popup menu.
If you turn off the “Insert Options” button while an inserted row, column, or cell is still highlighted, the button still displays. The next time you insert a row, column, or cell, the “Insert Options” button will not display.
If you’re a big Word and Excel user, you may open and save several documents in a day. Word and Excel are set by default to save in your My Documents folder on Windows XP or Documents library on Windows Vista/7. This default location is OK if you’re a home user but may not be ideal if you’re in a work environment where mapped drives and other network shares are common. In this guide I will show you how to change the default file opening and saving location for two common Microsoft Office programs, Word and Excel.
Microsoft Word Step one: Open Word and navigate to the Microsoft Office Button (or simply the File menu if you’re using Office 2010) and click Word Options. Step two: In the new window, click Save on the left side. Step three: Click Browse next to the Default File Location box and select the folder that you wish to be the new default opening and saving location and click OK when finished. You can also type the path to the directory if you wish. Microsoft Excel Step one: Open Excel and navigate to the Microsoft Office Button (or simply the File menu if you’re using Office 2010) and click Excel Options. Step two: In the new window, click Save on the left side.
![Options Options](/uploads/1/2/5/5/125591081/486650831.jpg)
Step three: For reasons unknown, Excel does not have a Browse button next to the Default File Location box so you’ll have to type the path to the directory of your new default opening and saving location. When finished, click OK. If you have any questions, be sure to comment below. Categories Tags.