Excel File Recovery

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 »

3 Quick Methods to Insert Special Symbols into Your Excel Cells

Special symbols can represent some special meanings. Therefore, in Excel, you will certainly need to insert some special symbols to assist your work. In an Excel worksheet, you will certainly input a lot of data and information into it. Sometimes you will also need to use certain special symbols for remarks. Here we will introduce three effective methods to help you insert those special symbols. Method 1: Special Symbols on the Keyboard You will certainly use the keyboard to type the data...

Read more »