How does EXCEL hide areas that do not need to be displayed?

1. As shown in the following figure, we will perform a test. First open the EXCEL file, and then select the hidden area.

2. Click "ctrl + 1" and then click "cell format" in the pop-up window. Of course, you can also select "cell" under the "format" menu"

3. Click "custom" in the "cell format" as shown in the following figure, and then enter ";" on the right.

4. Then, you can see that the table is empty. However, when you click "select", you will see the content in the formula column.

Friendship

In this way, if I hide it, it will still be printed out. If I want to hide it before printing it out, we can try to refer to other related articles on this site.