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
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details