Categories：Excel Tips
-
How To Use the SORT Function—Easy Tutorial
Today, we are going to learn the usage of the SORT function. The SORT function can help us to sort the rows and columns in a data range. Now, let’s check this out. Syntax: =SORT(array,[sort-index],[sort-order], [by_col] Array: The range of cells that is to be sorted. (Required) [sort-index]: The number of the specific row or […]
-
How To Use The SEQUENCE Function In Excel-Easy Understanding Tutorial
Today, we are going to learn the usage of the SEQUENCE Function. Learning to use functions can always make complicated things to be easier. The Syntax of SEQUENCE Function: =SEQUENCE (rows,[columns],[start],[step]) Rows: The number of rows to be returned. Columns: The number of columns to be returned. The default value is 1. (Optional) Start: Starting […]
-
How to Sort by Color in Excel?
Sometimes we highlight value or important data in different colors for different purposes. If we need to use color ranking or sort by color in Excel. What should we do? There is a price table for fruits. We can see that the prices in March and April are different. So, we can get the growth […]
-
How to Remove Chinese Text from Cells in Excel?
In our today’s tutorial, we would like to talk about how to delete Chinese text from worksheets in Excel. Actually, you can solve this with VBA code. But most people are not familiar with this. So, let’s use the easiest way to handle it. It only needs three steps to finish. Step 1: Copy and […]
-
How To Change The Font Color On Certain Text In Excel？
Have you ever tried to change the font color on certain text in one cell in Excel? You maybe think of this as very simple. You can test in a worksheet now. It’s would not be such simple as your thoughts. Let’s take an example. Change the font color of the word “your” to red […]
-
How To Quickly Split Cell Content In Excel From One Cell To Multiple?
Do you know how to split cell content in Excel? For example, there are eight product names in one cell. Product type, number, price, and tax rate also have eight kinds. What can we do to split this content into eight cells? There is a super easy and useful way that you really should know. […]
-
How To Remove Blanks In Excel Cells?
Do you know how to quickly delete or remove blanks in the cell? There are three different scenarios. So we are going to know how to delete useless blanks in different ways. No.1 I want to search the scores of HappyMaryy, Excel, and Do. But when I enter these names into. No score result shows […]
-
How To Highlight The Growth Rates In Excel?
There is a table about the growth rates from the year 2015 to 2016. How to calculate the growth rate? Growth rate =Starting value– End value/starting value. So we got several rates here. Some negative growth rates and some normal growth rates. If I want to quickly highlight the negative growth rates in green […]
-
How To Split Words Into Separate Cell In Excel?
Today, we are going to learn a very easy but useful trick how to split words into separate cells. A case in point is the following picture. There are roughly 30 name words in cell A1. Now we need to divide these words into separate cells. Press Ctrl and H to quickly open the Find […]
-
How To Use Sparkline In Excel?
Here is a table of seven brand sales from January to June. If we want to clearly see the sales trend of these companies. Inserting sparkline is obsoletely the best way. Select cell B2, and go to the insert tab to choose Line. Choose the right Data Range and Location Range, then hit Ok. Use […]
