Categories：Excel Tips
-
How to Insert a Per Mille Sign in Microsoft Excel
Making spreadsheets in Microsoft Excel often involves mathematics, which probably requires you to type percentages and per mille in the cell. So, how to enter them in an Excel sheet? You may already know that a percentage sign (%) can be typed with pressing Shift+5. But the way to insert a per mille sign (‰) […]
-
How to Make a Treemap in Microsoft Excel
Treemap is a simple chart in which you can see the value of each item from the spreadsheet clearly and intuitively. It’s a little bit like pie chart but not that focusing on showing each item’s share of the total. If you’d like to try creating a treemap in your Excel file, here’s the method: […]
-
How to Change the Color of Tabs in Microsoft Excel
The color of inactive sheet tab is gray, and active or selected sheet tab is white by default in Excel. If you have a lot of sheets to deal with, it might be hard to find a specific one quickly. In this case, you could change the color of tabs to differentiate sheets. So how can […]
-
How to Change the Resolution of Microsoft Excel
A high resolution in Excel will significantly increase the size of the document. Accordingly, you can control the file size by selecting a proper resolution. For example, if you need to send an EXCEL file with mail, free up more space on your hard drive, or reduce its upload / download time on Internet, you […]
-
How to Search Data in Microsoft Excel
This might occur to you some time when you use specific data incorrectly while working with Excel. What’s worse, the data reappears in the file irregularly, which means you will spend a lot of time searching and modifying. Here I’ d like to share the tip of how to search data in Excel. Here’s the […]
-
5 Practical Excel Functions to Improve Your Working Efficiency
Microsoft Excel is a widely used office software which you must have tried or at least heard in life. It’s convenient, powerful and also complicated for some newbies since there seems to be too much to learn. They may end up doing repetitive work manually without knowing how to use Excel formulas to complete their […]
-
How to Turn Off Auto Save in Microsoft Excel
Auto save is a convenient feature in Microsoft Office programs to avoid unexpected data loss. With it, you can find the edited file back even if you didn’t save it before accidents like power outages and computer breakdowns occurring. But there’re also downsides – it may cause lags sometimes especially when the configuration of your […]
-
How to Change the Default Saving Format of Microsoft Excel
When you create a new Excel file and want to save it for the first time, it can’t be saved directly but requires you to choose the location and format for saving. If you don’t have any special need to meet, you can let the format stay as default, which is Excel Workbook (*.xlsx), of […]
-
How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data
VLOOKUP is a very useful Excel function which can easily search through a column and find the corresponding data. For example, you can search for the score of a student in class quickly according to his or her name. The basic formula for VLOOKUP is: =VLOOKUP (lookup_value,table_array,col_index_num,range_lookup) “lookup_value” refers to the keyword for searching; “table_array” […]
-
How to Change the Default Font of Excel 2019
Every time you open an Excel file, the font will turn back to the default setting even if you’ve changed it for tons of times in previous file. To fit your taste more, you can change the default font of Excel actually. Click File tab on the top-left corner. Click Options in the left sidebar. […]
