Excel File Recovery

How to Print Comments in Your Excel Worksheet

Sometimes you need to print comments in your Excel. And here we will introduce the method to print comments. In an Excel worksheet, you will add some comments for certain cells. When you need to print the worksheet, you may also need to print the comments. Thus, you will get the entire information on the paper. In this image, you can see that there are two comments in the worksheet. And now if you need to print the comments together with the worksheet, you can follow the steps...

Read more »

How to Embed a Scrollable Area inside Your Excel Worksheet

If there are a lot of data and information in Excel, it will be cumbersome to view data. Therefore, you can embed a scrollable area in Excel. In the image below, you can see the sales volume of many sales representatives. You need to move the worksheet of you want to check other numbers. Now instead of moving the whole worksheet, you can also embed a scrollable area for this range. Embed a Scrollable Area in Worksheet In this part, we will show you the steps to embed such a scrollable...

Read more »

2 Functions to Calculate Weighted Averages in Your Excel

Sometimes you will calculate the weighted averages for your data. Here you can use two functions to calculate it quickly. In Excel, you will certainly do many calculations. Among those calculations, you will sometimes need to calculate the weighted average. For example, there are sales volumes of different products. The image below shows the sales volume of one representative. Here you need to calculate the weighted average of different sales representatives. And the weight of different...

Read more »