Short cuts of excel (hide and unhide)


CA Ramsai N (Fresher)     10 September 2013

CA Ramsai N
Fresher 
 61 likes  594 points

| My Other Post

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)

2 Like
avater

Vandana J Doshi (Practising Company Secretary)     10 September 2013

Vandana J Doshi
Practising Company Secretary 
 1976 likes  12557 points

View Profile | My Other Post

thanks for the info....

avater

CA Ramsai N (Fresher)     12 September 2013

CA Ramsai N
Fresher 
 61 likes  594 points

View Profile | My Other Post

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  



Popular Discussion


view more »