Excel Solutions

How to Protect Your Privacy via Removing Personal Information from Excel Files

The personal information in Excel files is very important for you. In this article, we will show you how to remove the personal information from Excel files to protect your privacy. Your computer will certainly contain your personal information. Therefore, when you create an Excel file in this computer, this file will also contain the corresponding personal information. When you need to send your Excel files to other people, you may wonder how you can remove the personal information from the...

Read more »

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 »