• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

what is the shortcut key to move the cursor to the first cell of the next row.

S

saurabh chauhan

New Member
Hello,

sir


what is the shortcut key to move the cursor to the first cell of the next row.


Eg. if i am working on cell C19 then is there shortcut key to move my cursor to cell A20
 
Hi Saurabh,


I think there is no dedicated shortcut key for it. Either you can Press and Hold Ctrl+Left Arrow then you will reach @ A19 and press down arrow or Press Ctrl+G and enter the Cell referance which you want to go.


Regards

Sreekhosh
 
Good day saurabh chauhan


Left arrow = Left

Right arrow = Right

Down arrow = Down

Up arrow = Up
 
Most shortcut keys consist of one or more keys, I do not think you can get much shorter than one key! if hitting a left/right/up/down arrow is not a shortcut key what is?
 
Saurabh


If you are entering data into that range

eg: A10:E30

Select the area

Now enter values but instead of pressing Enter press the Tab key

Excel will shift from Column E to Column A in the next Row automagically
 
@OldChippy


I don't claim to have invented that one, so you are free to plagarise, it as I have.


I have used Automagically enough to fill up 10 pages in Chandoo's search: http://chandoo.org/wp/search/?q=Automagically
 
Good day oldchippy


Automagically is a term used when the user either doesn't want to go into the technical details of something or doesn't know the details but does know what the end result has to be. The term is sometimes used in planning and design discussions and trade show demonstrations. For example, one might say:


"Our new CD-ROM will put a handy button on your computer desktop automagically. You won't even have to think about it."


The term is a playful variation of automatically .
 
@oldchippy, Hui, b(ut)ob(ut)hc

Hi!

I used to use (and still use to) the expression "mathemagical games" to refer to the section "mathematical games" than Martin Gardner had in Scientific American.

http://www.scientificamerican.com/article.cfm?id=profile-of-martin-gardner

Regards!
 
You must log in or register to reply here.
Back
Top