Excel hides cell contents rows and columns Sheets

1. Hide cell contents

Select the range of cells you want to hide. On the Format menu, click Cells, click the Number tab, in the Category box, click Customize, and then type a semicolon in the Type box of three half-width;;;. Click the OK button.

At this point, the contents of these cells will not appear in the cells in the worksheet, but when you click a cell, the contents will appear in the formula bar. If you do not want to display its contents in the formula bar, continue with the following action.

2. Hide the contents of the formula bar

Select the range of cells you want to hide again, on the Format menu, click Cells, click the Protection tab, select the Hidden check box, and click OK. Next, select the Protect submenu on the Tools menu, click Protect Sheet, and then select the Protect worksheet and locked cells check box, and then type the password in the password to Unprotect sheet box. " Click the OK button. Tutorial

, if you need to display the contents of these cells in the formula bar, on the Tools menu, select Protect submenu, click Unprotect Sheet, and to display its contents in a cell, delete the custom in the Type box when formatting cells;;;; " Symbols can be.

3. Hide rows and columns

There are special forms like "payroll", "personnel records, etc. may often need to hide the worksheet before printing" grade "," Birth date "," Deduction fee standard "and other ranks, in the editing and display, such repeated switching is more troublesome. There is a simple way to quickly hide and display the specified ranks. To hide the "c:d", "G", "J" columns,

Select the c:d column, click Data/Group and outline/mix, and the 1, 2 buttons on the worksheet are displayed (Figure 2). Repeat this step, select the G column, the J column to combine. Now you can hide the "c:d", "G", "J" columns by clicking the 1 button, and then restore the display by clicking the 2 button. The same is true for row settings, except that the 1, 2 buttons on the line are left. A

hidden row or column is selected when it is selected by dragging or by pressing the SHIFT key, and after copying and pasting, the hidden content is also copied. For this, you can select the area by dragging or pressing the SHIFT key, and then press ALT +; Key, so that only visible cells are selected, not the rows or columns that are hidden.　　

Tip: A generic object or graphic will be hidden by default along with the row you are in, and if you don't want to hide the graphic at the same time, double-click the graphic to open the Format Picture window, and on the Properties tab, select the size, position fixed option.

4. Hide Sheet

Click Tools/Macros/visual Basic Editor, select the sheet name you want to hide from the left side of the pop-up window, such as "Sheet4", and set the value of the "Visible" item to 2 in the Properties window- xlSheetVeryHidden "(Figure 3), if no Properties window can be displayed by F4. Then right-click VBAProject (Xxxx.xls) to select VBAProject Properties, select Lock Project on view on the Protection tab, and enter a password to save the document exit. When you want to expand VBAProject (Xxxx.xls) will pop up a request to enter a password dialog box, no password will not want to view or modify. A worksheet that is hidden with this method cannot be hidden by clicking Format/sheet/unhide, nor does it affect other worksheet operations.