banner_ad

Short cuts of excel (hide and unhide)

Excel 1156 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..


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
11 May 2026
Post office

Post office

Anakapalle

Others

View Details
Company
ARTICLESHIP 30 April 2026
Article Assistant

J SINGH & ASSOCIATES

Ahmedabad

CA Inter

View Details
Company
ARTICLESHIP 27 April 2026
CA Articled Assistant

GM Corporate Solutions

Noida

CA Final

View Details
Company
ARTICLESHIP 02 May 2026
Accounts and Audit Assistant

Kothawade and Laddha

Thane

B.Com

View Details
Company
ARTICLESHIP 14 May 2026
CA ARTICLE

PRAVEEN GARG & CO

Faridabad

CA Foundation

View Details
Company
14 May 2026
Financial Analyst - Remote Finance Expert

HiringBridge

Ahmedabad

CA

View Details
Company
04 May 2026
Articleship

S.K Gairola & CO

New Delhi

B.Com

View Details
Company
08 May 2026
Paid Assistants

Quick Taxperts Private Limited

Bengaluru

Graduate (Any)

View Details