Excel Solutions

2 Ways to Set Color to Alternate Rows or Columns in Excel

Excel has many powerful features that attract people to use it. And today we will introduce two ways to set color to alternate rows or columns in Excel. Excel is usually used to store and analyze data and information. And it is sometimes difficult for us to read the data in white color. Therefore, you can add different colors into different rows and columns. And with different color in different rows or columns, it is much easier for you to see the information in a big worksheet. But adding...

Read more »

3 Efficient Ways to Import External Data into Excel

Excel is very powerful in dealing with information. And today we will launch 3 methods to import external data into Excel. In your daily life, you will use some files to store some daily affairs. For example, you will use the text document to store shopping list. But later you need to import external data into Excel to arrange the information. However, you may find that the format of the pasted information in the Excel like this: Therefore, here we have three methods to import external...

Read more »

How to Use the Replace Feature to Change Your Cell Formats in Batch

There are many features in Excel. And some of them do favor to our work with simple steps. And we find such a substitute function contained in the Replace feature. Usually, you will use the Replace feature to find and replace some certain elements. And here is a sample of using the Replace feature to change cell formats. And in the image below, you can see many scores of students. And you need to select all “A” of those scores and change the format to highlight the good scores. But...

Read more »