Excel File Recovery

How to Write Protect Specific Cells or Formulas in Your Worksheet

It is natural that all of us want to protect cells with important values. In this article, we will explore the feature of cells protection in Excel. The cells protection in Excel will take effect when the worksheet is protected. You can lock a cell or hide a cell to protect it. But the different options will take different effects, which depends on whether the value in a cell is an ordinary content or a formula. Therefore, in the following sentences, we will find how the cells protection...

Read more »

2 Quick Methods to Create an Attractive Comment with Custom Shape in Excel

If you are bored with the default comment shape, you can also change it according to your own preference. The default shape of comment is the same as the image below shows. But today, you can also change the shape. There are two different methods to change the comment shape. But actually you will use two different objects in Excel. Let’s see how the two different methods work and find out their difference. Method 1: Make the Shape Serve as Comment Shape is a very common feature in...

Read more »

4 Basic Usages of IF function in Excel

IF function is a widely used function in Excel formulas. In this article, we will discuss about its basic usage. IF function will judge the values that you give and return the corresponding result. Although the basic usage is very simple, you can still fulfill many complex tasks through the combination of IF function and other functions. 1.The Basic Usage Here you can know the original usage of the IF function. In this image, you can see the sales volume of a sales...

Read more »