excel

%3CLINGO-SUB%20id%3D%22lingo-sub-445076%22%20slang%3D%22en-US%22%3Eexcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-445076%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20the%20first%20rows%20of%20a%20sheet%20have%20been%20hidden%2C%20how%20can%20I%20make%20them%20visible%20again%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-445076%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-445165%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-445165%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320107%22%20target%3D%22_blank%22%3E%40rob1-_%3C%2FA%3E%20%2C%20you%20may%20position%20your%20mouse%20here%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20113px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F108431i08ABA29CB0D4BEA5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eyou'll%20see%20the%20icon%20with%20two%20horizontals%20and%20up%2Fdown%20arrows.%20Left%20click%20and%20drag%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-446912%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-446912%22%20slang%3D%22en-US%22%3EAs%20an%20alternative%2C%20type%20A1%20in%20name%20box.%20Press%20Shift%20and%20click%20A2%20to%20select%20A1%3AA2.%20Press%20Ctrl%2BShift%2B9%20to%20unhide%20rows.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-447355%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-447355%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320107%22%20target%3D%22_blank%22%3E%40rob1-_%3C%2FA%3E%26nbsp%3B%2C%20couple%20other%20alternatives%20(actually%20one%20taking%20into%20account%20hiding%20the%20row%20that%20actually%20means%20assigning%20to%20it%20zero%20height)%20-%20select%20row%202%20and%20with%20keep%20pressing%20left%20button%20drag%20up.%20After%20that%20from%20right%20click%20menu%20Unhide%3B%20or%20Home-%26gt%3BFormat-%26gt%3BAutoFit%20Row%20Height%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-533159%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533159%22%20slang%3D%22en-US%22%3Eworks%20ok%20when%20the%20double%20lines%20appear%20then%20right%20click%20and%20select%20the%20unhide%2C%20ok.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-533182%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533182%22%20slang%3D%22en-US%22%3E%3CP%3EAnother%20alternative%2C%20select%20all%20rows%2Fcolumns%20(click%20above%20row%201%20and%20to%20the%20left%20of%20column%20A)%2C%20go%20to%20%3CSTRONG%3EHome%20tab%20%26gt%3B%20Format%20%26gt%3B%20Hide%20%26amp%3B%20Unhide%20%26gt%3B%20Unhide%20Rows%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20will%20unhide%20any%20rows%20(also%20works%20for%20columns).%20Can%20be%20handy%20if%20you%20don't%20know%20where%20something%20is%20hiding.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-534282%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-534282%22%20slang%3D%22en-US%22%3EAnd%20I%20am%20running%20windows%2010%20professional%20with%20office%20365%20home%20addition%3CBR%20%2F%3Ein%20your%20response%20you%20talk%20about%20the%20home%20tab%20then%20the%20format%20well%20the%20format%20does%20not%20appear%20in%20my%20most%20current%20addition%20which%20is%20the%20inciters%20version%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-534320%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-534320%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F334200%22%20target%3D%22_blank%22%3E%40francis_dymond%3C%2FA%3E%26nbsp%3B%2C%20that%20is%20here%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20470px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112260iC4F9715C27480E54%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

When the first rows of a sheet have been hidden, how can I make them visible again?

7 Replies

@Deleted , you may position your mouse here

image.png

you'll see the icon with two horizontals and up/down arrows. Left click and drag down.

As an alternative, type A1 in name box. Press Shift and click A2 to select A1:A2. Press Ctrl+Shift+9 to unhide rows.

@Deleted , couple other alternatives (actually one taking into account hiding the row that actually means assigning to it zero height) - select row 2 and with keep pressing left button drag up. After that from right click menu Unhide; or Home->Format->AutoFit Row Height 

works ok when the double lines appear then right click and select the unhide, ok.

Another alternative, select all rows/columns (click above row 1 and to the left of column A), go to Home tab > Format > Hide & Unhide > Unhide Rows.

 

This will unhide any rows (also works for columns). Can be handy if you don't know where something is hiding.

 

Best wishes

Damien

And I am running windows 10 professional with office 365 home addition
in your response you talk about the home tab then the format well the format does not appear in my most current addition which is the inciters version

@francis_dymond , that is here

image.png

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies