Excel Solutions

2 Effective Solutions to Solve Errors when Copying Formulas

Most of the time, we will use Excel to do some calculating. During the process, we will certainly use the formulas in Excel to help speed up the process. Thus, we have the ways to solve errors when copying cells with formulas. The formula in Excel shows its powerful capabilities. But in some cases, we need to use the results produced by those formulas in other worksheets. If we don’t know which number is the result of calculation, we will meet with some troubles. If we simply copy it and...

Read more »

2 Ways to Move or Swap Columns or Rows in Excel

In an Excel file, sometimes you may input some information to the wrong cells. Hence you should change the position. Therefore, today we have the Excel tips of moving or swapping columns or rows in a worksheet. Sometimes in an Excel file, you need to input a lot of information into it. But things are not always perfect, and Excel files are no exception. There is a possibility that you need to switch information of different columns or rows. And for instance, here you can see a worksheet of...

Read more »

Recover Your Unsaved Excel Spreadsheets via AutoSave & AutoRecover Features (Part II)

In the previous part, we have introduce the setting of saving AutoRecover information and the condition of closing the existing file without first saving it. And the following are the other two conditions. Except closing existing files without first saving it, there are two other specific conditions. Now follow us and know the detail information. Case 2: Closing a New File without First Saving it In this condition, you set a new Excel file and input into some information. However, you...

Read more »