Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Unhide ALL cells, rows and columns

  1. #1
    Join Date
    21st August 2003
    Posts
    83

    Unhide ALL cells, rows and columns

    Hi,

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

    Any suggestions gratefully received,

    Mike

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th January 2003
    Location
    UK
    Posts
    2,743
    Hi Mike,

    How about:
    VB:
    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

  3. #3
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    19,808
    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.

  4. #4
    Join Date
    21st August 2003
    Posts
    83
    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 at 22:55. Reason: Can't attach file

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    19,808
    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.

  6. #6
    Join Date
    21st August 2003
    Posts
    83
    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?

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Transpose Groups Of Cells From Columns To Rows
    By bergersworth in forum HIRE HELP
    Replies: 7
    Last Post: May 1st, 2009, 00:28
  2. Columns & Rows Will Not Unhide
    By AAE in forum Excel General
    Replies: 2
    Last Post: March 29th, 2007, 02:34
  3. Vba To Unhide Rows, Print, And Rehide Rows
    By yeti911 in forum Excel General
    Replies: 6
    Last Post: February 9th, 2007, 08:06
  4. Unhide Rows/Columns Of Used Data Range
    By jimmya3556 in forum Excel General
    Replies: 3
    Last Post: August 11th, 2006, 02:31

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno