Announcement

Collapse
No announcement yet.

Unhide ALL cells, rows and columns

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Unhide ALL cells, rows and columns

    Hi,

    Is it possible to unhide all rows and columns in a workbook?

    Any suggestions gratefully received,

    Mike

  • #2
    Hi Mike,

    How about:
    Sub Unhide_All_Rows()
    On Error Resume Next
    'in case the sheet is protected
    ActiveSheet.Cells.EntireRow.Hidden = False
    End Sub

    Sub Unhide_All_Columns()
    On Error Resume Next
    'in case the sheet is protected
    ActiveSheet.Cells.EntireColumn.Hidden = False
    End Sub
    HTH
    Cross-poster? Read this: Cross-posters
    Struggling to use tags (including Code tags)? : Forum tags

    Comment


    • #3
      Do you want a manual or VBA solution?

      manually you can select all cells by clicking the grey box at the left between A & 1. Then use the Format Menu to unhide.
      Hope that Helps

      Roy

      New users should read the Forum Rules before posting

      For free Excel tools & articles visit my web site

      If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

      RoyUK's Web Site

      royUK's Database Form

      Where to paste code from the Forum

      About me.

      Comment


      • #4
        I think I need a VBA solution, as I would like to do it for all sheets in the workbook.

        Actually, the reason why is that I have noticed a problem/bug with hiding rows. Where all rows beneath a chosen area have been hidden, so that the available excel window is reduced - i.e. it doesn't scroll all the way to row 65536 - it doesn't seem possible to unhide these rows.

        Example:

        In the attached sheet, it is not possible to unhide any rows past 67, effectively limiting excel.

        Anybody experienced this before or knows a fix?

        **EDIT - Can't attach file as it is 75KB despite having nothing visible (cleared all formats and values) **
        Last edited by MisterT; November 4th, 2004, 22:55. Reason: Can't attach file

        Comment


        • #5
          Have you run Richie's code?
          Hope that Helps

          Roy

          New users should read the Forum Rules before posting

          For free Excel tools & articles visit my web site

          If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

          RoyUK's Web Site

          royUK's Database Form

          Where to paste code from the Forum

          About me.

          Comment


          • #6
            Yes. All very strange.

            It appears that I have somehow tricked excel into redefining the range...

            Does anybody have storage that I can post the file to?

            Comment

            Working...
            X