Short cuts of excel (hide and unhide)

Excel 992 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