2 Methods to Quickly Get the Number of Rows or Columns of a Selected Range in Excel

Sometimes you need to know the number of rows and columns of a selected range in the worksheet. In this article, we will introduce two methods for you. When you select a range in the worksheet and you haven’t released your mouse, you will see the row number and column number of the area in the name box. However, the moment you release your mouse, the number will disappear. It is hard for you to remember the number all the time. What if you need to get the number the next time? Here we...

Read more »

2 Methods to Sort a Column with both Numbers and Texts in Your Excel

Sometimes in a column, the cells will contains both numbers and texts. Here we will provide two methods to sort a column with numbers and texts. Sometimes there will be numbers and texts in the same cells in a column. If you need to sort this column, you will meet with problems. The order of the column will not be “1,2,3,4,5..”, but it will be “1,10,11,12,…2,21,22…”. Therefore, this kind of order will make your worksheet in a mess. In order to solve such a problem and sort the...

Read more »