Excel suddenly hides rows & columns & not unhideable

Question

Excel suddenly hid a significant number of rows & columns.

And I can't unhide.

I already tried the following method:

"In the top left corner of your spreadsheet, there's a triangle icon in between the first row and A column. Clicking on this icon, select the entire spreadsheet, click on the Home tab, Format icon and select to unhide rows from the drop-down menu that appears"

but it didn't work. Please see in the video recording below.

https://www.dropbox.com/s/2jdjmh7z9tl2040/Video_2023-06-29_191328.wmv?dl=0

(Microsoft does not allow upload video file, so I could only share via link to video hosted on dropbox)

Answer 1

Is it possible that the pane has been frozen? View->Window->Unfreeze

If not, try the following:

Type Ctrl-G (to bring up the GoTo box)

Enter a cell that is hidden (e.g., A1)

Type Alt-O (format) R (row) U (unhide)

If this unhides the row in question, then

Type Ctrl-G

Enter a hidden cell

Shift-click on a visible cell below (or above) the hidden row

Type Alt-O, R, U to unhide the rows

The same procedure should work for columns when you type Alt-O, C, U

Answer 2

Hi,

Well, I'd suggest you try unhiding them using VBA-

• Open the VBA Editor using Alt + F11.
• Upon opening, click on "Insert" in the menu and choose "Module" to insert a new module.
• Enter the following code-

Sub UnhideAll()     
	Rows.Hidden = False 'Unhide all rows     
	Columns.Hidden = False 'Unhide all columns 
End Sub

• Close the VBA Editor and return to your Excel spreadsheet.
• Press "Alt + F8" and open the "Macro" dialog box.
• Select the "UnhideAll" macro and click "Run" to execute it.

This should fix your issue.

Best Regards.