标签：Excel
-
How to Sort Data by Font Color in Microsoft Excel
When editing a worksheet, sometimes you might change the color of the font to make the it more readable. And in some cases, like analyzing monthly sales data, you need to sort data by font color in Excel, which could help to understand your data better, quickly find what you want and make more effective […]
-
How to Compare Two Excel Worksheets Side by Side
If you want to compare two worksheets with similar or related data, switching to one window then switching back is apparently not the best idea. Let the two worksheets both display on the screen side by side. You can make a more intuitive and convenient comparison. You may know that Windows already have the feature […]
-
How to Insert a Hyperlink to Microsoft Excel
You’ve probably seen some tables containing hyperlinks in which you can click those texts with underlines to open a new web page and view more information. Inserting hyperlinks to Excel is actually a very simple yet pratical trick. Let’s see how to do it. 1. Select the cell you want to add a hyperlink. 2. […]
-
3 Methods to Wrap Text in Microsoft Excel
Microsoft Excel doesn’t wrap text by default, no matter how much text you enter in one cell. This could lead to the content of cells beside being covered, and finally affect the layout of the entire Excel spreadsheet. To avoid this , you can try these methods to wrap text in Microsoft Excel manually or […]
-
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 […]
-
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 […]
