Unhide Rows doesn't work - Exxcel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1122787%22%20slang%3D%22en-US%22%3EUnhide%20Rows%20doesn't%20work%20-%20Exxcel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1122787%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20Excel%20365.%26nbsp%3B%20I%20hid%20some%20rows%20on%20a%20spreadsheet%20for%20readability.%26nbsp%3B%20But%20when%20I%20went%20to%20unhide%20them%20(highlighted%20adjacent%20visible%20rows%2C%20right-click%2C%20Unhide)%20nothing%20happened...%2C%20the%20rows%20remained%20hidden.%26nbsp%3B%20Tried%20clicking%20on%20divider%20but%20same%20result...%20rows%20remain%20hidden.%26nbsp%3B%20Saved%20spreadsheet%20with%20hrows%20hidden%2C%20exited%20Excel%20and%20restarted%2C%20re-opened%20file%2C%20same%20results.%26nbsp%3B%20So%20are%20my%20hidden%20rows%20lost%20forever%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1122787%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1123226%22%20slang%3D%22en-US%22%3ERe%3A%20Unhide%20Rows%20doesn't%20work%20-%20Exxcel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1123226%22%20slang%3D%22en-US%22%3EHmmm%3CBR%20%2F%3ENever%20heard%20of%20this%20but%20I%20would%20try%20the%20following%3A%3CBR%20%2F%3ECtrl%2BA%20to%20highlight%20everything%20in%20the%20sheet%2C%20change%20row%20height%20of%20any%20visible%20row.%20This%20should%20also%20unhide%20all%20rows.%3CBR%20%2F%3EIf%20that%20doesn't%20work%2C%20can%20you%20post%20the%20file%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1157347%22%20slang%3D%22en-US%22%3ERe%3A%20Unhide%20Rows%20doesn't%20work%20-%20Exxcel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1157347%22%20slang%3D%22en-US%22%3E%3CP%3EHad%20the%20same%20problem.%20Did%20a%20Save%20As%20to%20a%20different%20name.%20Deleted%20all%20the%20merged%20cells%2C%20which%20were%26nbsp%3Beither%20complete%20columns%20or%20complete%20rows%20on%20the%20spreadsheet.%26nbsp%3B%20The%20hidden%20rows%20popped%20up%20without%20me%20doing%20anything%20further.%26nbsp%3B%20Am%20going%20to%20send%20this%20spreadsheet%20back%26nbsp%3Bto%20the%20originator%20%26amp%3B%20let%20him%20put%20the%20merged%20cells%20back%20in.%26nbsp%3B%20I%20never%20use%20merged%20cells%20--%20they%20cause%20too%20many%20problems%20with%20Excel.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1247253%22%20slang%3D%22en-US%22%3ERe%3A%20Unhide%20Rows%20doesn't%20work%20-%20Exxcel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1247253%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F528619%22%20target%3D%22_blank%22%3E%40rocki2900%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EI%20got%20them%20back%20by%20scrolling%20the%20screen%20back%20towards%20column%20A.%20Very%20annoying!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2008256%22%20slang%3D%22es-ES%22%3ERe%3A%20Unhide%20Rows%20doesn't%20work%20-%20Exxcel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2008256%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20have%20the%20same%20problem%20and%20nothing%20works.%20Even%20worse%2C%20if%20I%20hide%20new%20rows%20to%20test%2C%20the%20rows%20are%20not%20displayed%20again.%20I've%20tried%20to%20give%20him%20vary%20the%20height%2C%20take%20a%20larger%20group%20of%20rows.%20Home%2C%20cells%2C%20display%20format.%20I%20kept%20my%20hoia%20in%20a%20new%20book%20and%20inherited%20the%20same%20problems.%20At%20this%20point%20I%20think%20about%20reinstalling%20Office.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Using Excel 365.  I hid some rows on a spreadsheet for readability.  But when I went to unhide them (highlighted adjacent visible rows, right-click, Unhide) nothing happened..., the rows remained hidden.  Tried clicking on divider but same result... rows remain hidden.  Saved spreadsheet with hrows hidden, exited Excel and restarted, re-opened file, same results.  So are my hidden rows lost forever???

4 Replies
Hmmm
Never heard of this but I would try the following:
Ctrl+A to highlight everything in the sheet, change row height of any visible row. This should also unhide all rows.
If that doesn't work, can you post the file?

Had the same problem. Did a Save As to a different name. Deleted all the merged cells, which were either complete columns or complete rows on the spreadsheet.  The hidden rows popped up without me doing anything further.  Am going to send this spreadsheet back to the originator & let him put the merged cells back in.  I never use merged cells -- they cause too many problems with Excel. 

@rocki2900 
I got them back by scrolling the screen back towards column A. Very annoying!

 

Tengo el mismo problema y nada funciona. Aun peor, si oculto nuevas filas para probar, las filas no vuelven a mostrarse. He probado darle  variar el alto, tomar un grupo mayor de filas. Inicio, celdas, formato mostrar. Guardé la hoia en un libro nuevo y heredó los mismos problemas. A estas alturas pienso en re instalar Office.