Excel File Recovery

3 Methods to Sum the Values of the Same Cells in Multiple Worksheets (Part I)

Excel has provided many features for us to calculate data. Here we will introduce 3 useful methods to sum values of same cells in multiple worksheets. Sometimes in an Excel file, you will need to calculate the total value of certain cells. However, those cells are in several different worksheets. In this image, you can find that there are three worksheets about the sales volume of different sales representative. And now you need to sum up the values of each person in the sheet of...

Read more »

2 Easy Ways to Hide Specific Rows or Columns in Your Excel

In our previous articles, we have talked about how to hide and show workbooks and worksheets. And now we will continue discussing about easy ways to hide specific rows and columns. There are three different objects of the hide and show feature: workbook, worksheet and rows or columns. And in this article, we will show you how to hide specific rows or columns in excel. To hide workbooks, you can refer to 2 Quick Steps to Hide Workbooks in Your Excel. To hide worksheets, you can refer to 2...

Read more »

2 Simple Methods to Hide Worksheets in Your Excel

In the previous article, we have talked about hiding and showing workbooks in Excel. And in this passage, you can follow us and hide or show Worksheets. There are three different objects of the hide and show feature: workbook, worksheet and rows or columns. And in this article, we will show you how to hide worksheets in excel. To hide workbooks, you can refer to 2 Quick Steps to Hide Workbooks in Your Excel. To hide specific rows or columns, you can refer to 2 Easy Ways to Hide Specific Rows...

Read more »