CCI Online Learning
What do you want to learn today?
     
CIBIL

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

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 »



Trending Tags
gst
ca students
Professional Resource
cbdt
epfo
itr
Service Tax
taxpayers
Info Technology
income tax
custom
icsi
dgft
eway bill
Others
newgstreturn
traces
ca rankholder interview
mca
cag
law
tcs
gstr 3b