Categories：Excel Tips
-
How to Insert Greater than or Equal to Symbol in Word and Excel
When editing content about numbers in Microsoft Word or Excel, the greater than or equal to symbol as well as other mathematics signs are indispensable elements that you need to enter every now and then. But apparently there’s no such a greater than or equal to key on the keyboard, you can only insert it […]
-
5 Methods to Insert Mathematical Symbols in Word
Have you ever been bothered by inserting a mathematical symbol in Word? After all, the current keyboard has been designed with very few common symbols. As for larger than or equal to symbol, approximately equal to symbol, not equal to symbol, etc., you can only insert them through other approaches. Here I’d like to share […]
-
How to Make Excel Files Compatible with Earlier Versions
If you work with a recent version of Excel like Excel 2016, Excel 2019, the workbook you created may not be displayed correctly in Excel 2003 or Excel 2007. Thus when you send your Excel files to your colleague or friends, there’s a chance they can’t open them normally. In this case, you’d better make […]
-
How to Quick Input Specific Words or Text in Microsoft Excel
If you want to type a great many repeated data in an Excel file like the information of gender, department, etc. There’s a quick way in addition to add drop-down list, which allows you to enter just a simple number and make it shown as specific word or text. Let’s see the detailed steps. Assuming […]
-
How to Quick Hide or Unhide Rows and Columns in MS Excel
When editing data in Excel spreadsheet, there may be some less important content you can’t delete but also don’t need to keep an eye on all the time. Hiding these rows or columns could make the table looks more compact without substantial impact for the data, and that’s exactly what I want to share in […]
-
How to Insert a Formula to Do Calculations in Microsoft Excel
Editing a worksheet referring to total amount or commercial profit usually needs some calculations. If it’s a complex operation, you may expend much time on it and the result could still be wrong. So how about letting Excel help you out? I’d like to share a quick guide of entering formula in Microsoft Excel here. […]
-
How to Insert Sparklines (mini charts) in Microsoft Excel
Sparklines are the mini charts in Excel cells that using simple and small graphs to present the status of data intuitively. Let’s see how to create and insert a sparkline inside a specific cell. The sheet below shows the incomes of A and B from January to December. Now I want a more intuitive view […]
-
How to Encrypt Your Excel Workbook with Password
An Excel File may contain some important data and information. To prevent peeking, you can encrypt the Excel workbook with a password to protect the data in it. Just follow these steps: 1. Open the file you want to encrypt. Click File on the top-left corner of Excel, tap Info on the left sidebar and […]
-
How to Insert a Picture as the Background of Excel
Working on the same sheet all day long and dealing with tons of data can be very exhausting. You may consider bringing some new colors to refresh the tired eyes. Changing the background seems like a good idea. 1. Switch to Page Layout tab and click Background in Page Setup section. 2. Then a window […]
-
How to Find the Maximum or Minimum Value in Excel
To find out the Maximum and Minimum value in a long list of data in Excel, one effective way is sorting data at first and then find the one you want in the beginning or in the end. But if you don’t want any change to the order of the data, there’s another simple method. […]
