How to hide part of the area in Excel completely

On the first day of work, my friend asked me to help him solve a problem about excel sheets: "I used excel2000 to make a worksheet for everyone to browse, and there are a few key data in it, I don't want them to see it, how should I set it up?" ”

Just set its text to white! I didn't think about it, so I replied to him directly.

No, although the content in the cell is invisible, it can still be displayed in the column after the cell is selected. ”

You can hide it. Another non-thinking reply.

How to hide? Select the cells you want to hide, execute the Format Cells command (or right-click the mouse and select the Format Cells option), open the Format Cells dialog box, click the Protect tab, select the check box in front of the Hide option, and exit OK. Then run the "Tools Protect Worksheet" command to open the "Protect Worksheet" dialog box, enter the password twice and exit.

1. After holding down the Ctrl key, use the mouse to left-click or drag on the cells (regions) that need to be selected, and you can select multiple cells (regions) that are not contiguous at one time. 2. For the security of data, please do not remove the "" sign in front of the "lock" option in the above dialog box!

Originally, I thought that everything would be fine in this way, but I didn't expect my friend Amin to call again: "Still no!" If you select one of these cells and the cells around them together, the contents will still be displayed!

I tried, and sure enough. It turns out that Excel added the "transparent" function in the 2000 and XP versions, and this "transparency" does not matter, but the content set to "white" is "transparent". Looks like I'm going to have to take this seriously.

Once again, I carefully looked at the help file of Excel, and after repeated tests, I found that the purpose of completely hiding the contents of the cells can be achieved by customizing the cell formatting method:

Or first select the cells that need to hide the content (of course, if protection is set, please choose to execute the "Tools Protect Cancel Worksheet Protection" command to unprotect the worksheet), open the "Format Cells" dialog box, click the "Number" tab (usually the default label), check the "Custom" option under "Classification", and then, enter "" in the box below "Type" on the right;; Three quotation marks in the English state), as shown in the figure, exit after confirmation. Then follow the methods mentioned above to set up "Hidden" and worksheet protection.

What do you think?! I can't get out of it now!

Note here: if you set it this way, you don't need to set the text to "white". At the same time, after setting this way, not only the contents of these cells will not be displayed, but also the entire worksheet cannot be modified, which is both confidential and secure.

How do I hide some of my data with a password?

Select the entire column, right-click on the options that appear, and select "Hide".

Tools Raw Materials:

Shenzhou K580P-i7 D3

windows7

excel2007

1. Open the excel software and open the required **.

2. Above **, click the column number and select the following cells that need to be hidden.

3. Press the key combination Ctrl + Shift + arrow keys to select all the cells that need to be hidden.

4. Right-click on the upper area, and select Hide from the pop-up menu.

5. Hide part of the cell area to complete.

1. Press alt+down arrow to automatically generate a drop-down list based on the content you have entered;

2. Press alt+= to quickly insert the summation formula;

3. Press Alt+Enter to force a line break at the specified position;

4. Select the entire area and press Alt+; When selecting, you can skip the hidden area and select only the displayed area;

5. Press the alt+number key to enter special symbols: for example, alt+41420 can be entered, alt+41409 can be entered;

6. Press Ctrl+D to fill down. Select a cell with a formula or value and the n cells below to fill the value or formula.

The steps to hide part of the data in excel are as follows:

Operating environment: Mechanical Revolution S3 Pro, Windows10, Excel2021.

1. First of all, select the data that needs to be hidden in the cherry blossoms, then right-click and select Set Format Cells.

2. Select Custom in the type, and enter the semicolon in English in the box"; Click OK when you're done entering.

3. At this time, you can see that the Songshi data can no longer be seen in **, but it can still be seen in the input box above.

4. To make the input box above also unable to see the data, to bring up the Format Cells dialog box again, in the Protection tab, check the Hide option, it should be noted that there is a prompt in this interface: only after protecting the worksheet, locking cells or hiding formulas is effective.

5. Click OK to set it hidden, and then click the Protection Worksheet option under the Review tab.

6. A new dialog box will pop up, you can set the password and other people's processing permissions on the worksheet as needed. Here you can directly follow the default settings and click OK.

7. After this setting is completed, click the cell again, and you will find that there is no data in the input box, and the data has been completely hidden.

The steps of the method are as follows:

1. Hidden**.

1. Open Excel, move the mouse to one of the ** names, then right-click and select Hide in the pop-up window.

2. Move the mouse to another ** name, right-click, and select Unhide in the pop-up window.

3. In the pop-up window, click OK.

4. In this way, the hidden ** is revealed.

2. Hidden rows or columns.

1. Open Excel**, select one column (one row is also OK), click the mouse or key, and select Hide.

2. After hiding, select another column, right-click, and select Unhide in the pop-up window.

3. In this way, the hidden column will be displayed.

3. Hidden content.

1. Move the mouse over the edge of the border of the hidden content until the cross appears.

2. After the cross sign appears, drag the border so that the hidden content will be revealed.

The hidden part of Excel shows the specific operation as follows:

Tools:MSI GF63THIN9SC, Windows 10, Excel2016.

1. Turn on the computer, go to Excel**, and click "Cells" in the "Start" page.

2. Select "Format Cells" in "Cells".

3. Click "Protect" in the "Format Cells" page.

4. Enter the "Protection" page and see that the front of the hide is checked.

5. Click the tick in the box in front of "Hide" to cancel, and click "OK" to display the hidden part.

Take the excel 2010 version as an example, the whole content of the following figure is hidden, directly to line 7, see the figure below.

At this time, select row 7 and hold down the left mouse button to move up until the row with the abc sequence is selected, release the mouse, click the right mouse button, and select "Unhide" in the pop-up box, see the figure below.

You can see that all the hidden content is displayed, as shown in the figure below.

Here's how to fix it:1. First of all, open the excel you want in the computer, and now you want to set the unhide rows, and check the cell area that you want to contain the hidden rows.

2. Then find [Format] in the [Start] toolbar of the ribbon above **, as shown in the figure below.

3. Then select [Hide and Unhide] from the drop-down options of [Format], as shown in the figure below.

4. Then in the drop-down options of [Hide and Unhide], click [Unhide Rows], as shown in the figure below.

5. At this time, you can see that all the hidden lines are displayed, as shown in the figure below.

The hidden part of Excel shows the specific operation as follows:

Tools:MSI GF63THIN9SC, Windows 10, Excel2016.

1. Turn on the computer, go to Excel**, and click "Cells" in the "Start" page.

2. Select "Format Cells" in "Cells".

3. Click "Protect" in the "Format Cells" page.

4. Enter the "Protection" page and see that the front of the hide is checked.

5. Click the tick in the box in front of "Hide" to cancel, and click "OK" to display the hidden part.