Excel table Hide and unhide worksheets, rows, columns

In Excel tables, we often hope that we can make good things to hide, do not be easily discovered by others. In addition to encrypting the form, there is a way to hide the worksheet or a row or column, so that even if someone opens your form, you can't see what's inside. Share some of the ways you can hide worksheets, rows, and columns in Excel.

1, Excel display and hide the worksheet method

2, Excel Hide and unhide rows, columns

---------------------------------------------------------------------------------------

1, Excel display and hide the worksheet method

The easiest way to do this is to click the "format" of the menu bar--the worksheet--to hide it, and at this point our current worksheet will be hidden immediately. If you want to show the worksheet that you just hidden, we just need the format--> worksheet--> Unhide to display the worksheet that we just hid.

--------------------------------------------------------------------------------------------------------------- --

2, Excel Hide and unhide rows, columns

If you want to hide a row and a column, the method is similar to the hidden worksheet method described above, first use the mouse you need to hide "a certain row" or "a column", and then choose "Menu bar" format--> column/row--> hidden can be implemented, want to show just hidden rows, columns Click to cancel the hidden.

How, the method is not very simple ah! I'm sure you've learned to hide the worksheet in Excel!