Categories：Excel Tips
-
How to Customize and Unify the Date Format in Excel Quickly
It’s quite troublesome to enter dates into Excel Spreadsheet with a canonical format manually. But if you don’t unify the format, it will affect the operation with formulas in the sheet. Therefore, I’d like to introduce 2 ways to unify the entered data and display them as the customized format. Method 1: Using Format Cells to […]
-
How to Add a Drop-down List in Excel
You must have seen some Excel spreadsheets with drop-down list. It’s quite convenient to select an option from the list instead of typing it by yourself. Therefore, I’d like to share some experiences of creating a drop-down list in Excel. 1. Select the cell you want to add drop-down menu. Click Data Validation in Data […]
-
How to Sum Multiple Excel Tables Across Sheets
It’s common to input data in different Excel spreadsheets by different people and sum them later. But as you know, if you copy a column of data and copy them into another table, the existing data will be overwritten. Is there a way to sum the data across multiple Excel tables in different sheets? How […]
-
How to Display Numbers as Asterisks in Excel Cells
When you log in some software, the password you entered will be displayed as asterisk to protect your privacy. In Excel, you can also achieve this effect to prevent some important data from being peeked by others. So how to display number as asterisks in Excel cells? It’s a very simple trick. You just need […]
-
How to Process Data with Units Using Functions in Excel
Some people tend to input the data with units into Excel spreadsheet considering it will be more clear and intuitive. But unfortunately, the data with manually entered units can’t be calculated correctly with Excel functions. It means you can only do the summation or subtraction manually as well. To avoid this situation and use functions […]
-
How to Use Function Keys F1 to F12 in Windows and Office
You may already know pressing [F5] key in Windows system can refresh the current page, and pressing [F11] can enable the full screen mode. But do you know the specific functions of all the keys from F1~F12? They do have different functions in Windows system (like the desktop, system folders, browsers, etc.) and Microsoft Office […]
-
How to Sort Data by Multiple Columns in Microsoft Excel
An Excel spreadsheet is often composed of multiple columns with various data, and they are all related in some way. You probably need to take more than one columns into consideration while sorting. So how to do it? The Sort feature in Excel allows you to add multiple levels as the criteria to sort the […]
-
How to Start Microsoft Word/Excel/PPT in Safe Mode
Safe mode is a kind of protection mechanism of Microsoft Office. When you open or close these documents in a wrong way or just install some plug-ins to them, Office applications may fail to work. At this point, you can still start Word, Excel, PowerPoint, etc. normally in safe mode. To make use of safe […]
-
How to Use AutoFill in Excel to Quick Enter a Series of Data
Microsoft Excel is a particular powerful tool. When you make use of it, there are lots of tips can help you process the data automatically. For example, if you want to enter a series of data or a line of increasing numbers into a spreadsheet, you don’t need to type them one by one manually. […]
-
How to Unify the Date Format in Microsoft Excel
To record a set of data in Microsoft Excel, you probably don’t think much about the format at the beginning. The data like dates can be entered in Excel with different formats by yourself or several different people. But things change, now you want to rearrange the dates in the spreadsheet. At this point, how […]
