Forum Discussion

M365Con's avatar
M365Con
Copper Contributor
Feb 18, 2025

Excel sheet Hidden Rows from 1 to 4080

how to unhide Rows on Excel work sheet ?

2 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor

    Click in the top-right corner to select all cells:

    Then right-click any of the row numbers and choose Unhide:

     

  • PGSystemTester's avatar
    PGSystemTester
    Copper Contributor

    If you [CTL] + A several times you should select your entire workbook, then right click on mouse and select unhide.

     

     

    If you can get to the VBA editor, you could do something more surgical like 

    Sub unhideTopRows()
        Dim ws As Worksheet
        Set ws = ActiveSheet
        Range(ws.Rows(1), ws.Rows(4000)).EntireRow.Hidden = False
    End Sub

     

Resources