What Is Data Hiding?

Select the range of cells you want to hide, right-click and select "Format Cells", select "Custom" from the "Classification" list on the "Value" tab, and enter three half-width points in the "Type" input box ";;;" (see Figure 1), then switch to the "Protection" tab, click to select the "Hide" check box, the cell content will be hidden after confirmation.

Data hiding

Click again

Some special forms like "payroll", "personnel records", etc. may often need to be hidden before printing

Click "Tools / Macros / Visual Basic Editor", select the name of the worksheet to be hidden on the left side of the pop-up window, such as "Sheet4", and set the value of the "Visible" item to "2-xlsheetveryHidden" in the properties window (Figure 3), if there is no property window, press F4 to display. Then right-click "VBAProject (XXXX.xls)" and select "VBAProject Properties", select "Lock Project While Viewing" in the "Protection" tab, and enter the password to save the document and exit. In the future, when you want to expand VBAProject (XXXX.xls), a dialog box asking for a password will pop up. Do nt want to view or modify it without a password. Worksheets hidden in this way cannot be unhidden by clicking "Format / Worksheet / Unhide", nor will it affect other worksheet operations.