close Change the way you learn with CCI Online Coaching   view more
Home > Community > EXCEL TIPS AND TRICKS > Forum


Please Wait ..

Sign-in to your account


Username:
Password:

Remember Me

Forgot your password?

Sign-up now



Join CAclubindia.com and Share your Knowledge. Registered members get a chance to interact at Forum, Ask Query, Comment etc.


EXCEL TIPS AND TRICKS



Owner : CA.Madhavan
579 Members
Created : 09/08/2008 13:01:18




Browse by Category




Popular Communities


Current Discusions Discussion Page


10 Time Saving Keyboard Shortcuts

By : CA.Madhavan

On : 21 August 2008
10 Time Saving Keyboard Shortcuts

Select Entire Row                      Shift +Space bar

Select Entire Column               CTRL+Space bar
Enter Current Date                    CTRL+Semi colon
Current time                               CTRL+ Shift+ Semi colon
Move within worksheets           CTRL+Space up or down
Hide Row                                    CTRL+9
Hide column                               CTRL+0
Switch Applications                    ALT+Tab
Insert Hyperlink                          CTRL+K(select the file,click OK)
To change Auto sum                 Right Click on bottom of the Excel Window(sum,count )etc)

By : ANSHUL SINGHAL

On : 08 January 2009
Nice Shortcut Keys

They are really nice; they helped me out in different ways. But I am not able to understand you’re "Move within worksheets". What I think is it would be Page Up or down rather than 'Space'.


By : pallavi

On : 13 January 2009
Re:

Really.........its good............................

Thank u................................


By : ABHISHEK ASOPA

On : 14 January 2009
Re:

Hii..!!

Really Nice dear ,dese vl surely help...!!

ReGarDs,

ABHI..ASOPA

CA, L.L.B


By : Hemant Hegde

On : 15 January 2009
Re:

But you know which is the favourite of all Articleship students????

its "ALT+TAB" friends.  ;-P

:)

:)


By : ***manish***

On : 02 March 2009
Re:

thnx dear...


By : Mukesh Kumar

On : 14 March 2009
Re:

thanks

for these tips.

can u tell me automatic formula for numeric cell to words cell

we write 500 in A4

how it can be in b5 or any other cell in words [ Five Hundred Only ]

 


By : vinay garg

On : 08 April 2009
Re:

really it,s good..................................

thanks.................................





Reply to this Discussion




You need to be logged in to post reply