Categories: Excel Tips
-
Methods To Insert Euqal Approximately Symbol
When we have to insert some special symbols in Excel, but there is no shortcut key for us to use. The article will show 2 methods to help you find these special symbols. Let’s take equal approximately symbol as an example. Method 1: Insert Approximately Equal Symbol First, open the form you want to edit. […]
-
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 […]
-
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 […]
