A very handy feature of Excel is its ability to hide rows and columns from a user without it affecting calculations in any way. This can be handy if you wish to hide calculations or certain information from a user. Hiding rows or columns can be performed in two ways, by selecting the row or column you wish to hide and going to Format>Row (or Column) >Hide or by selecting the row or column that you wish to hide, right clicking and selecting Hide.
Let’s have a look at this now.
Lets unhide the column now.
As mentioned above, you can also perform the hide/unhide operation by right clicking and selecting either Hide or Unhide from the shortcut menu. This is my preferred option, but it is up to you which one you use.
Lets have a go at hiding some rows, using the right click option.
You should now have two rows hidden, but your formula result will still be 500.
Lets unhide the rows now.
You can also hide sheets using Format>Sheet>Hide. You need to be aware that the right click option is not available if you wish to hide a sheet. You must do it via Format>Sheet. As with hidden rows and columns you can still reference the hidden sheet via a formula and have it return the correct value. Of course though it is wise to reference the sheet while it is visible and use the mouse pointing method to build your reference and then hide it.
If you go to Format>Sheet>Hide and the UnHide is greyed out this means there are no Worksheets hidden within the Workbook. If there are sheets hidden the Hide will not be greyed out and selecting it will display the Unhide dialog box. Within this box will be the names of all hidden sheets, to unhide one simply select the sheet name from the box and clicks OK or double click it (the sheet name).
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Go back to:
|Lesson 1 - Excel Fundamentals|
|Lesson 2 - Starting Excel and Excel Workbooks|
|Lesson 3 - Excel Toolbars and Task Panes|
|Lesson 4 - Excel Worksheets|
|Lesson 5 - Excel Cells and Navigating a Worksheet|
|Lesson 6 - Excel Cut/Copying and Pasting Data|
|Lesson 7 - Excel Copying with the Fill Handle|
|Lesson 8 - Excel Paste Special|
|Lesson 9 - Excel Insert Command|
|Lesson 10 - Excel's default options|
|Lesson 11 - Excel's Undo and Redo|
|Lesson 12 - Excel's Format Painter|
|Lesson 13 - Excel's Dates and Times|
|Lesson 14 - Excel's Custom Formats|
|Lesson 15 - Excel Formulas|
|Lesson 16 - Excel Cell References|
|Lesson 17 - Excel: Avoid Typing|
|Lesson 18 - Excel Formulae Arguments & Syntax|
|Lesson 19 - Excel Autosum Formula|
|Lesson 20 - Excel Auto Calculate|
|Lesson 21 - Excel's Insert Function|
|Lesson 22 - Excel's Useful Functions|
|Lesson 23 - Excel's Named Ranges|
|Lesson 24 - Excel's Constants and the Paste Name Dialog|
|Lesson 25 - Excel's Calculations|
|Lesson 26 - Excel Comments Cell|
|Lesson 27 - Excel Find and Replace|
|Lesson - 28 - Clear Excel Cell Contents|
|Lesson 29 - Effective Excel Printing 1|
|Lesson 30 - Effective Excel Printing 2|
|Lesson 31 - Sorting in Excel|
|Lesson 33 - Auto-Formats in Excel|
|Lesson 34 - Creating a Basic Excel Spreadsheet|
|Lesson 35 - Excel Charting Lesson: The Basic Excel Spreadsheet|
|Lesson 36 - Excel Worksheet Protection|
|Lesson 37 - Excel IF Formula Nesting|
|Lesson 38 - Excel Function Now/Today Formulas|