Excel Tip: Shortcut with Tables / Regions August 12th, 2013

Vinod Kumar

Last week I wrote about Copy Values from Formula cells and a number of folks had expressed interest in knowing more shortcuts when working with Tables. This blog post I will show some of these commonly used shortcuts for Tables inside Excel. I am sure there are many more available with excel that you would like to share with our readers, please feel free to drop a line under comments section.

For this example, I am going to use a simple table as shown above. Now our cursor is in C4 cell and we will play with a number of shortcuts next.

Select Cells one-by-one

This is a basic shortcut, If you need to select cells adjacent to C4 one-by-one. Use SHIFT + Arrow. We can use the up arrow, down arrow or the side arrows to select in the directions we want to select cells.

Select Cells till the edge of region

Moving cell-by-cell can be time consuming. So if you want to select till the edge of the row. We can use SHIFT+CTRL+Arrow key. Below we used the right arrow key to select till the edge.

Select current Line

If above was a neat trick, then what will be the shortcut to select the complete row. That would be SHIFT+Spacebar. From C4 cell you can see we have selected the row edge-to-edge in the example below.

Select current column

Now to select the complete column edge-to-edge of values. the shortcut would be CTRL+Spacebar. From C4, the selection would look like below.

Select current REGION

Now for a strange reason you want to select the complete region. We can combine, the shortcut of row selection and then column to get the same effect. Even better combination is CTRL+A.

Hope these shortcuts will be useful when you play with Tables / regions inside Excel next time. Do let me know if you have alternate shortcuts for the same.

Tags: , , , , , , , , , ,

This entry was posted on Monday, August 12th, 2013 at 08:30 and is filed under Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

6 Responses to “Excel Tip: Shortcut with Tables / Regions”

  1. Mayank Jain says:

    One correction for select cells one by one…instead of CTRL + ARROW ITS SHIFT + ARROW

  2. Beena says:

    Thanks Vinod.

    Your explanation of using these keys in your story(formulas) are very easy to understand and it lasts longer in our brain.

    Thanks for all your efforts in writing this blog, it helps many of us.

    Well Done!

    Kind Regards,

  3. Joseph Flesche says:

    SHIFT / CTRL + Spacebar are new to me! Thanks for sharing!

  4. Beena says:

    Great stuff….shortcuts key saves lots of time.

    To have complete Excel Keboard shortcuts….see below:

    Just reading the shortcuts key won’t help, make use of these keys in your daily use, it will come in your habit.


    • Vinod Kumar says:

      Yes, that is a good point. I will be covering a lot of these shortcuts in the future too and how I use it daily. Thanks for your note Beena !!!

Leave a Reply