Short cuts of excel (hide and unhide)

Try this ::: to hide / unhide in excel

 

1.Control(hold) + 0(press and realse)  = to hide column

 

2.Shift(hold) + Cntl (press and realse) + 0 = to  Unhide (select the cells, where in between hided column exsits)

 

3.Control(hold) + 9(press and realse)= to hide the Row

 

4.Shift (hold)+ cntl + 9 (press and realse) = to un hide Rows (select the cells, where in between hided row exsits)

Replies (2)

thanks for the info....

Don't use Numeric Key pad to press "0" or "9", use the numbers under Functional keys..

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
29 July 2026
ACCOUNTANT

ONESTEP GST SOLUTION

New Delhi

B.Com

View Details
Company
28 July 2026
Senior accountant

RJ Public School

Bengaluru

B.Com

View Details
Company
ARTICLESHIP 16 July 2026
CA Article

Pipara & Co. LLP.

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 17 July 2026
Article Assistant and B.com pass

BANSAL YOGESH AND CO

Gautam Budh Nagar

B.Com

View Details
Company
ARTICLESHIP 23 July 2026
Article

Gianender & Associates

New Delhi

CA Inter

View Details
Company
16 July 2026
CA Inter, CA Intermediate, CA IPCC, CA CPT , CA SemiQualifie

Vakilsearch.com

Chennai

CA Inter

View Details
Company
11 July 2026
CA semi qualified

Vakilsearch.com

Chennai

CA Inter

View Details
Company
20 July 2026
Senior GST Executive

Chandak Agarwal & Co

Mumbai

Graduate (Any)

View Details
Follow