归档： 2019 August 20
-
How to Change the Default Save Location in Microsoft Excel
When you done with a workbook and save it, Excel will save it to My Documents folder automatically. But sometimes you need to save the workbook to another folder which is more consistent with the use of your habits. In this case, you need to select the correct location in the Save As dialog box, […]
-
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 […]
