Excel has many hidden features which can also be set according to your need. Thus, today we will introduce the 4 user interface gadgets in Excel.
When you create a new Excel file, you will find that there are some small features. Those features include the mini toolbar, live preview and others. However, those features are not fixed. And you can change the settings according to your operation custom. Thus, today we will show the 4 options about the user interface.
The mini toolbar will appear when you select the number or word in a cell. Thus, you can change the format in the mini toolbar. However, sometimes, you select the value but you don’t want to change the format. But the mini toolbar will cover other contents like the image shows, which will disturb you to read other data.
So here you can close the toolbar.
- Click the tab “File” on the ribbon.
- Then click “Options”.
- On the right, you can see the part of “User Interface options”. Uncheck the first choice “Show Mini Toolbar on selection”.
- And then click “OK”. Thus, when you select the value in a cell, the toolbar will never show up. Still you can right click and the toolbar of setting format will show up.
When you copy and paste certain information, sometimes you need to copy the values with the format. Thus, the live interview is necessary. In Excel, the default setting of the live preview is checked.
It is recommended that you keep the setting. Therefore, you can preview the result in case you choose the wrong option.
The third of the interface is the color scheme. And the default setting is silver. You can also click the small arrow to choose another color.
For example, here we choose the color black, and the interface will change.
This is much cooler that the default setting!
This is the last setting in “User Interface”. When you move your mouse to any of a button on the toolbar, there will be a box of explanation.
Here you move the mouse on the “Conditional Formatting”, you can see that there is an explanation on it. And if you are very familiar with all the features, you can certainly close it. Click the small arrow and you will see the three options.
You can choose any of the options according to your need.
Repair Damaged Excel Files by a Useful Tool
Excel can sometimes corrupt due to various reasons. Thus, you can use a third party tool to repair Excel files. In case you have input some important information into it, you need to recover your files as soon as possible. Otherwise, you will lose your data and information, which could cause worse result.
Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com