OzGrid

Lesson 32 - Hide/Show Row/Columns in Excel

< Back to Search results

 Category: [Excel]  Demo Available 

HIDE/SHOW ROW/COLUMNS IN EXCEL

 

Lesson 32 - Excel Hiding/Unhiding Rows and Columns. Hide Columns/Rows in Excel. Level 1 Free Training

HIDE/SHOW ROW/COLUMNS IN EXCEL

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.

  • On A New Worksheet, Click In B2 And Type 100. In C2 Type 100, In D2 Type 100, In E2 Type 100, In F2 Type 100.
  • Click In G2 And Use The AutoSum Feature On Your Standard Toolbar To Sum The Range B2:F2.
  • Select The Entire Column D By Selecting The Column Reference (The D With The Grey Background).
  • Go To Format>Column>Hide.
  • You Will Notice Now That Column D Has Disappeared, But The Result Of Your Formula, 500 Has Not Changed. This Is Because You Have Only Hidden The Column, Not Deleted It.

Lets unhide the column now.

  • Highlight The Entire Columns C And D Go To Format>Column>Unhide.
  • Notice That You Have Now Unhidden Column D.

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.

  • In B3 Type 100, In B4 Type 100, In B5 Type 100, In B6 Type 100, B7 Type 100.
  • In B8 Use The AutoSum Feature To Sum The Range B3:B7.
  • Now Select The Entire Row 3 By Selecting The Row Reference.
  • Right Click And Select Hide.
  • Select The Entire Row 5 By Selecting The Row Reference.
  • Right Click And Select Hide.

You should now have two rows hidden, but your formula result will still be 500.

Lets unhide the rows now.

  • Highlight Rows 2 To 7.
  • Right Click And Select Unhide.

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

See also:

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

 

See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.

 

 

 


Gallery



stars (0 Reviews)