Forum Discussion
M365Con
Feb 18, 2025Copper Contributor
Excel sheet Hidden Rows from 1 to 4080
how to unhide Rows on Excel work sheet ?
2 Replies
Sort By
- JKPieterseSilver Contributor
Click in the top-right corner to select all cells:
Then right-click any of the row numbers and choose Unhide:
- PGSystemTesterCopper 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