Excel on Windows 10

%3CLINGO-SUB%20id%3D%22lingo-sub-2665154%22%20slang%3D%22en-US%22%3EExcel%20on%20Windows%2010%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2665154%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20unhide%20multiple%20Rows%20of%20data%20that%20are%20hidden%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2665154%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2665258%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20on%20Windows%2010%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2665258%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1132339%22%20target%3D%22_blank%22%3E%40sweetanita%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClick%20on%20the%20row%20number%20of%20the%20row%20above%20the%20hidden%20rows.%3C%2FP%3E%0A%3CP%3EThen%20hold%20down%20Shift%20while%20clicking%20on%20the%20row%20number%20of%20the%20row%20below%20the%20hidden%20rows.%3C%2FP%3E%0A%3CP%3ERight-click%20anywhere%20in%20the%20selection%20and%20select%20Unhide%20from%20the%20context%20menu%2C%20or%20select%20Format%20%26gt%3B%20Hide%20%26amp%3B%20Unhide%20%26gt%3B%20Unhide%20Rows%20on%20the%20Home%20tab%20of%20the%20ribbon.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How can I unhide multiple Rows of data that are hidden? 

1 Reply

@sweetanita 

Click on the row number of the row above the hidden rows.

Then hold down Shift while clicking on the row number of the row below the hidden rows.

Right-click anywhere in the selection and select Unhide from the context menu, or select Format > Hide & Unhide > Unhide Rows on the Home tab of the ribbon.