Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / 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,745
    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
    18,028
    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

    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 21:55. Reason: Can't attach file

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,028
    Have you run Richie's code?
    Hope that Helps

    Roy

    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 3 users browsing this thread. (0 members and 3 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. Excel 2007 Demo: Hide or unhide rows and columns
    By Dave Hawley in forum Downloads (no questions)
    Replies: 0
    Last Post: November 29th, 2008, 14:25
  3. Columns & Rows Will Not Unhide
    By AAE in forum EXCEL HELP
    Replies: 2
    Last Post: March 29th, 2007, 02:34
  4. Vba To Unhide Rows, Print, And Rehide Rows
    By yeti911 in forum EXCEL HELP
    Replies: 6
    Last Post: February 9th, 2007, 07:06
  5. Unhide Rows/Columns Of Used Data Range
    By jimmya3556 in forum EXCEL HELP
    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