Short cuts of excel (hide and unhide)

1167 views 2 replies

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
ARTICLESHIP 24 June 2026
ARTICLE ASSISTANT

BHUPINDER SHAH AND COMPANY

New Delhi

CA Inter

View Details
Company
25 June 2026
AUDIT MANAGER

JDAS & ASSOCIATES

New Delhi

CA

View Details
Company
Featured 24 June 2026
HEAD - AUDIT AND TAXATION

A R JADHAV AND ASSOCIATES

Mumbai

CA Inter

View Details
Company
25 June 2026
Accounts & Taxation Executive

Dindukurthy & Associates

Hyderabad

MBA

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details
Company
01 June 2026
Audit, Taxation & Compliance Executive

R P S K & Associates

Nashik

CA Inter

View Details
Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details
Company
20 June 2026
Chartered Accountant

ANV & Company

New Delhi

CA

View Details