Use CTRL+Back Space to jump to active cell [Shortcut]

Posted on May 27th, 2010 in Learn Excel - 9 comments

Use CTRL+Backspace to jump to active cell

When I published the comprehensive list of excel shortcuts few weeks back, I thought I had them all. Boy, I was wrong. I am pleasantly surprised to find a new shortcut, one that takes away my manic mouse scrolling in one feel swoop. Often, when I am working with large tables of data, I scroll down or right and want to get back to active cell. This is where CTRL+Back Space is very useful. It will bring you back to active cell.

Other keys you can use to quickly jump around:

  • Use CTRL+Arrow keys to last cells in the direction of arrow (if you have blanks in between, you go to the cell before blank)
  • Press CTRL+G and type the address of a cell you want to go to
  • Use CTRL+Page Dn, Page Up to access next and previous sheets
  • CTRL+Tab, CTRL+SHIFT+Tab to access next and previous workbooks
  • More navigation shortcuts

What are your favorite shortcuts for navigation?

Learning how to navigate with keyboard alone can be a huge time saver. I would love to know what shortcuts you use to navigate faster when you are working with excel sheets. Please share your tips using comments.

Written by Chandoo
Tags: , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

9 Responses to “Use CTRL+Back Space to jump to active cell [Shortcut]”

  1. Gregor Erbach says:

    CTRL+PageDn (CTRL+PageUp) also works in Firefox for moving to the next (previous) tab, so that I need only one shortcut for my two most frequently used applications.

  2. Jon says:

    Hi,

    this one is great for Excel.

    long time ago, i used to love the Shift+F10 combination, it triggers the contextual menu (like when your mouse is knocked out and your keyboard's an elder one).

  3. alan says:

    ctrl + home and ctrl + end to jump to the beginning and end

  4. Fakhar says:

    Just a suggestion that please if it's possible start using video presentations vis-a-vis written instructions as by watching a small video we can understand the same concept quickly & easily than by just reading a long list of instructions

    Thanks

  5. Rick Rothstein (MVP - Excel) says:

    Your tip requires both hands to perform it... when I want to return to the active cell, I simply press the right arrow key followed by the left arrow key (only requires one hand). Of course, this won't work correctly if you are in the last column (although in that case, you could press the left arrow key followed by the right arrow key).

  6. Rick Rothstein (MVP - Excel) says:

    Okay, let me restate what I posted... sure, you could perform the Ctrl+Backspace with just your right hand (although I always use my left hand for pressing the Ctrl key), but it is sort of an an awkward maneuver to perform whereas pressing the right/left arrow keys in succession is pretty easy to do.

  7. Chandoo says:

    @Rick.. I agree that using arrow keys is another elegant and simple way to jump to active cell.

  8. David Coop says:

    Hi Chandoo,

    A navigation tool I like is to disable the EDIT IN CELL option. This means that when you double click in the cell, you are taken to the first mentioned cell reference in the formula. This can be VERY useful, because it works across the whole workbook. It will even open a closed workbook. To return to the cell, just press F5 and enter. Construct you formulas with this in mind, and navigation to the source of the calculation in a cell is simple.

    The only downside is the need to enter in the FORMULR BAR, but for me, the benefits outway this minor disadvantage.

    Regards,

    David

  9. Abhishek says:

    Hi,

    I want to submit an excel tip but not sure whether it has been published earlier or not so pls ignore if it has been already published.

    Tip Name: Showing the comment as part of the formula
    Procedure: = + N("Insert the comment here")
    I found this as a good technique to reference something related to your formula specially when you don't want to show an usual excel comment.

    Thanks.

Leave a Reply