Hidden cells in Excel 2010, the contents of the ranks, the program worksheet

Hide the cell contents
Select to hide the contents of Office 2010 Excel range of cells, right-click select the "Set Format Cells", in "data" option project "category" icon in the selection of "custom" in the "type" three half-width of the input box, enter a semicolon "\; \; \;", and then switch to the "protection" option item, click to select the "hidden" recovery option to determine the cell contents after it was hidden .
Then click menu "Protection / Protect Sheet ...", password protect the worksheet, you can completely hide the cell contents. To unhide must first click the menu "to protect / undo protect the work sheet." Then from the "Set Format Cells" in the selection of the appropriate data format, or range of cells selected, click the menu "Edit / Clear / format" to restore the display.
Is worth to note that the protection of worksheet cells can not be modified. If you want to protect the cell can modify the contents of the input demand can be selected cell, choose the right "to set the Format Cells" from the "protection" option to cancel the project, click "Lock" recovery option before the "√", then protect the sheet set. This is the hidden cell can still enter or modify, but entered the cell contents will be hidden.
  Hidden ranks
There are special forms such as "payroll," "personnel records" and may often need to hide a worksheet before printing the "level", "Birth", "Standard deductions" and other ranks, they need to show editing out, repeat this switch is more troublesome. This has an easy solution to quickly hide, show specified ranks. To hide the "C: D", "G", "J" column, for example:
Select "C: D" column, click the menu "value / Group and Outline / combination", this time will be displayed on the worksheet grade 1 and 2 buttons.
Repeat this step, each selected column G, J column combination. Now just click a button to hide the "C: D", "G", "J" column, click the 2 button to restore the display. The setting is the same for the line, only line 2 button is on the left.
Hidden rows or columns by dragging the selection or press the Shift key when selected will also be selected, copy and paste the contents will also be found hidden copied the.This can drag the selected area or press the Shift key, then press "Alt + \;" button, this will only select visible cells, not including those hidden rows or columns.