How to Select Cells in Excel Using Keyboard (9 Ways)

Sometimes you need to Select Cells in Excel Using Keyboard Shortcuts When working with a large dataset. Keyboard Shortcuts make it easier to Navigate a Cell. In this article, we will learn how to select cells in Excel using several keyboard shortcuts.

Here we have a dataset of Six American Novel Name with Writers Name & Publishing Year. We will learn to Select various Cells in Excel Using Keyboard Shortcuts with this dataset.

How-to-Select-Cells-in-Excel-Using-Keyboard


Download Practice Workbook


9 Ways to Select Cells in Excel Using Keyboard

Method 1. Select Adjacent Cells Using Keyboard

In this method I will show you How to Select Adjacent Cells Using Keyboard.


1.1. Select One Cell Up

Here, I will try to move the selection one Cell up by using keyboard shortcut.

STEPS:

  • Suppose you are at Cell C7 & now you want to Select Cell C6. To move one Cell Up Press Up Arrow or press SHIFT + ENTER.

  • Following the above Shortcut will take you to one Cell Up.


1.2. Select One Cell Down

Now, I will try to move the selection one Cell Down by using keyboard shortcut.

STEPS:

  • Suppose you are at cell C5 you want to move one Cell down or in Cell C8.  To move one Cell Down Press Down Arrow or press ENTER.

  • Following the above Shortcut will take you to one Cell Down.


1.3. Select One Cell Right

In this section, I will demonstrate how to move the selection one Cell Down by using the keyboard shortcut.

STEPS:

  • Suppose you are at Cell C7 & now you want to Select Cell D7. To move one Cell Right Press Right Arrow or press TAB.

  • Following the above Shortcut will take you to one Cell Right.


1.4. Select One Cell Left

Here, I will try to move the selection one Cell Left by using the keyboard shortcut.

STEPS:

  • Suppose you are at Cell C7 & now you want to Select Cell B7. To move one Cell Left Press Left Arrow or press SHIFT + TAB.

  • Following the above Shortcut will take you to one Cell Left.

How-to-Select-Cells-in-Excel-Using-Keyboard

Read More: How to Select Multiple Cells in Excel without Mouse (9 Easy Methods)


Method 2. Using Keyboard Shortcuts to Select Edge Cells Having No Empty Cell

In this method, we will discuss how to Select Edge Cells without Empty Cells.

STEPS:

Suppose you are at Cell B5 initially & you want to navigate Edges of your dataset having No Empty Cells. Following Shortcuts will help you to do so. I will show you to navigate the Edges in a cyclic manner.

  1. To move Down Edge of the dataset: Press CTRL + Down Arrow.
  2. To move Right Edge of the dataset: Press CTRL + Right Arrow.
  3. For selecting Up Edge of the dataset: Press CTRL + Up Arrow.
  4. To move left Edge of the dataset: Press CTRL + Left Arrow.

How to Select Cells in Excel Using Keyboard

Read More: Data clean-up techniques in Excel: Filling blank cells


Method 3. Select Edge Cell Using Keyboard Having Empty Cells

Here I will show you how to Select Edge Cells with Empty Cells.

STEPS:

Suppose you have a dataset having Empty Cells. If you want to Select the Edge Cells of your dataset following Method 2’s Shortcut will work. But it will work in a slightly different way & now I will show you the difference.

  • Initially, you are at Cell C5 & you want to Select the Down Edge Cell of Column C.

  • Upon pressing CTRL + Down Arrow, It will take you to Cell C6 which is the last Non-empty Cell in the direction.
  • So CTRL + Arrow Key always takes you to the last Non-empty Cell.

How to Select Cells in Excel Using Keyboard

  • Now, if you press CTRL + Down Arrow again, It will reach Cell C8 or the first non-empty Cell.
  • So we can say that, If your Adjacent Cell is an Empty Cell, Pressing CTRL + Arrow Key will take you to the first Non-empty Cell in the direction.

How to Select Cells in Excel Using Keyboard

  • Finally pressing CTRL + Down Arrow again will take you to the Edge of Column C or Cell C10.

Read More: Select All Cells with Data in Excel (5 Easy Methods)


Method 4. Selecting First Cell & Last Used Cell in Excel

In this method, I will show you How to Select the First Cell & Last Used Cell Using Keyboard.

STEPS:

Suppose you are at the End of a big dataset & now you want to move to the Top. Scrolling with Mouse is very tedious for a big dataset.

  • In that case following the Keyboard Shortcut CTRL + Home will take you to the Top of your dataset.

How to Select Cells in Excel Using Keyboard

If you want to move to the End of your dataset, Follow the keyboard Shortcut CTRL + End. It will take you to the last used Cell of your dataset.

Read More: How to Select Cells with Certain Value in Excel (5 Methods)


Method 5. Select Multiples Cells Using Keyboard Shortcut in Excel

In this method, I will show you How to Select Multiple Cells Using Keyboard.


5.1. Select Multiple Cells in Right Direction

Here we will learn how to Select Multiple cells in Right direction.

STEPS:

Suppose you are at Cell C7 & you want to Select the Right Cell or Cells of the same Row simultaneously. Let me explain it to you.

  • To do this you have to follow the Keyboard Shortcut SHIFT + Right Arrow.
  • To select another Cell in the same direction keep holding the SHIFT key while pressing Right Arrow

How to Select Cells in Excel Using Keyboard

  • Now you will have both Cell C7 & Cell D7 selected.

How to Select Cells in Excel Using Keyboard


5.2. To Select Multiple Cells in Down Direction

Now we will see how to Select Multiple cells in the Down direction.

STEPS:

If you are at Cell C7 & you want to Select the Down Cell or Cells of the same Column simultaneously you can do it by following the method explained below.

  • To do this you have to follow the Keyboard Shortcut SHIFT + Down Arrow.
  • Cell C9 is an Empty cell. So, SHIFT + Arrow Shortcut selects both Empty & non-Empty Cells.

How to Select Cells in Excel Using Keyboard

  • To select Multiple numbers of Cells in the same direction keep holding the SHIFT key while pressing Down Arrow again to Select each cell.

How to Select Cells in Excel Using Keyboard


5.3. Selecting Multiple Cells in Up Direction

Here we will learn how to Select Multiple cells in Up direction

STEPS:

Now, you are at Cell C7 & you want to Select the Up Cell or Cells of the same Column simultaneously.

  • To do this first select cell C7
  • Then, you have to follow the Keyboard Shortcut SHIFT + Up Arrow.

How to Select Cells in Excel Using Keyboard

  • To Select another Cell in the same direction keep holding the SHIFT key while pressing Up Arrow each time to Select each Cell.

How to Select Cells in Excel Using Keyboard


5.4. To Select Multiple Cells in Left Direction

Sometimes we need to Select Multiple Cells at Left. Now we will see how to Select Multiple cells in the left direction.

STEPS:

  • Suppose you are at Cell D7 & you want to Select the LEFT Cell or Cells of the same Row simultaneously.
  • To do this you have to follow the Keyboard Shortcut SHIFT + Left Arrow.

How to Select Cells in Excel Using Keyboard

  • To select another Cell in the same direction keep holding the SHIFT key while pressing Left Arrow each time to Select each Cell.

How to Select Cells in Excel Using Keyboard

Read More: Multiple Excel Cells Are Selected with One Click (4 Causes+Solutions)


Similar Readings


Method 6. Selecting a Range of Cells

Suppose you want to Select a Range of Cells from your dataset instead of Selecting them one by one. In that case the CTRL + SHIFT + Arrow Shortcut Key can help you to Select a Range of Cells.


6.1. Selecting Range of Cells in Down Direction Using Keyboard

Here, I will show you How to Select a Range of Cells in Down Direction.

STEPS:

  • Suppose you are at Cell B6 & you want to Select all Cells Down of the Same Column.
  • Press CTRL + SHIFT + Down Arrow

How to Select Cells in Excel Using Keyboard

  • Now you will have a Selected Range of Cell B6:B10.

How to Select Cells in Excel Using Keyboard

  • Now if you press CTRL + SHIFT + Down Arrow key again & if there is no non-Empty Cell in that direction, This Shortcut Key will Select all the Cells till the End of that Column.

How to Select Cells in Excel Using Keyboard


6.2. Selecting Range of Cells in Up Direction

Now I will demonstrate how to Select a Range of Cells in Down Direction.

STEPS:

  • Suppose you are at Cell C9 & you want to Select all Cells Up of the Same Column.
  • Press CTRL + SHIFT + Up Arrow

How to Select Cells in Excel Using Keyboard

  • Now you will have a Selected Range of Cell C96:C4.

How to Select Cells in Excel Using Keyboard


6.3. Selecting Range of Cells in Left Direction Using keyboard

Here I will demonstrate how to Select a Range of Cells in Left Direction.

STEPS:

  • Initially, you are at Cell D7 & you want to Select all Cells Left of the Same Row.
  • Press CTRL + SHIFT + Left Arrow

How to Select Cells in Excel Using Keyboard

  • Now you will have a Selected Range of Cell D7:B7.

How to Select Cells in Excel Using Keyboard


6.4. Selecting Range of Cells in Right Direction Using keyboard

In this section, we will see how to Select a Range of Cells in Left Direction.

STEPS:

  • Suppose you are at Cell C7 & you want to Select all Cells Right of the Same Row.
  • Press CTRL + SHIFT + Right Arrow.

How to Select Cells in Excel Using Keyboard

  • Now you will have a Selected Range of Cell C7:D7.

How to Select Cells in Excel Using Keyboard

  • Now if you press CTRL + SHIFT + Right Arrow key again & if there is no non-Empty Cell in that direction, This Shortcut Key will Select all the Cells till the End of that Row.

Read More: How to Select a Range of Cells in Excel Formula (4 Methods)


Method 7. Using Keyboard Shortcut to Select All Used Cells in Excel

In this method, I will show you how you can select all used Cells Using multiple Keyboard Shortcuts.


7.1. Select All Used Cells Till the End Cell Using Keyboard

In this section, I will discuss how to Select All used Cells till the End.

STEPS:

  • Suppose you are at Cell B8 & you want to Select All Used Cells till the End.
  • To have the desired Cells Selected press CTRL + SHIFT + End.

How to Select Cells in Excel Using Keyboard

  • Now you will have All Cells Selected till the End.

How to Select Cells in Excel Using Keyboard


7.2. Select All Used Cells Till the First Cell Using keyboard

Now I will discuss how to Select All used Cells till the First cell.

STEPS:

  • Suppose you are at Cell D13 & you want to Select All Used Cells till the First Cell.
  • To have the desired Cells Selected press CTRL + SHIFT + Home.

How to Select Cells in Excel Using Keyboard

  • Now you will have All Cells Selected till the beginning.

How to Select Cells in Excel Using Keyboard

Read More: Select All Cells with Data in a Column in Excel (5 Methods+Shortcuts)


Method 8. Selecting Non Contiguous Cells Using Keyboard in Excel

In this method, I will show you how you can Select Non Contiguous Cells.

STEPS:

  • Selecting the Non Contiguous Cells is very easy using CTRL Key.
  • Just keep pressing the CTRL key while Selecting desired Cells.
  • It does not matter if they are Contiguous or not, Empty or Not.

There is another way to Select Non Contiguous Cells without pressing CTRL Key.

STEPS:

  • First, select any Cell or Cells.
  • Then press SHIFT + F8. In this way, your selection will be locked.
  • Now you can click any Cell or Cells & all of them will be selected.
  • To unlock Selection again press SHIFT + F8.

How to Select Cells in Excel Using Keyboard

Read More: How to Move Selected Cells in Excel with Keyboard (4 Methods)


Method 9. Using Keyboard to Select Entire Row or Column in Excel

In this method, I will show you how to select an Entire Row or Column Using Keyboard.


9.1. Select Entire Row Using keyboard

In this section, I will show you how you can Select Entire Row.

STEPS:

  • Initially I have selected Cell C7 & I want to Select all Cells of Row 7.
  • To Select all Cells of Row 7 press SHIFT + Spacebar.

How to Select Cells in Excel Using Keyboard

  • Now we will have the entire Row 7 selected.

How to Select Cells in Excel Using Keyboard


9.2. Select Entire Column Using Keyboard

In this section, I will show you how you can Select an Entire Column.

STEPS:

  • Initially, I have selected Cell C7 & I want to Select all Cells of Column C.
  • To Select all Cells of Column C press CTRL + Spacebar.

How to Select Cells in Excel Using Keyboard

  • Now we will have the entire Column C selected.

Read More: How to Drag Cells in Excel Using Keyboard (5 Smooth Ways)


Practice Section

Here I have provided a practice sheet for you. Try it!

How to Select Cells in Excel Using Keyboard


Conclusion

In the article above we have learned several methods to Select Cell Using Keyboard. Applying those techniques in our daily life will make our job easier. I hope you enjoyed reading this article. If you have any query please leave a comment. Stay safe!


Related Articles

Asif Khan Pranto

Asif Khan Pranto

Hello! I'm Asif here, currently working with Exceldemy as an Excel & VBA Content Developer. I write articles on Exceldemy about various ways to get out of Microsoft Excel's stuck conditions. My goal is to work with an organization which will give myself a chance to upgrade besides having a real impact on our surroundings. I'm passionate about travelling new communities & trekking. In my leisure period I usually read books. I've completed graduation in Mechanical Engineering & now I am pursuing Master of Development Studies to experience a new spectrum of knowledge. I’ve always been interested in research and development. So, here I will be posting articles related to Microsoft Excel. Hoped this may help you. Thank you.

2 Comments
  1. Great Tutorial
    Maybe I missed it.

    I have multiple columns A to Z, each of different lengths (null cells within data and end of some columns).

    I select B4 to E4
    What shortcut will allow me to select all remaining rows down to last cell with data?

    • Hi Colin Kinsella,
      Hope you are doing well.

      You can select multiple columns from A to Z having different lengths.
      Here, we created a dataset in Cell range A4:Z6. Then, we selected Cell B4:E4 similar to your dataset.

      1. Select Cells

      After selecting Cell range B4:E4 or any other cells, press CTRL+A on your keyboard to select all remaining rows with data.

      2. Select Cells

      Thanks.

      Regards,
      Arin Islam

Leave a reply

ExcelDemy
Logo