Selecting Column(s) or Row(s) Using Keyboard Shortcuts in Microsoft Excel

While preparing reports and dashboard in MS Excel keyboard shortcuts, its time-consuming to select the entire column or row using the mouse. These excel shortcuts are useful to save time and help you do your work faster using the keyboard shortcut keys. How to select rows or columns with the Excel shortcut?

In this article, we will learn how to select Row or Column or a table using keyboard shortcut keys.

Selecting cells is a very common function in Excel. It performs many tasks like addition, deletion and width adjustment of multiple rows and columns while applying the formula on data in Excel. Shortcut keys to select all rows and columns can provide an easier and quicker method of using MS Excel 2016. We have a data set here, let’s understand with the example.

Excel Keyboard shortcuts to Select Column

  • Select the cell, you wish to select.
  • Use Ctrl + Space shortcut keys from your keyboard to select the column as shown below in the picture.

If you wish to select the adjacent columns with the selected column, use Shift + Left/Right arrow key(s) to select the left or right side of that column. You can go either way but can’t access both sides of it.

We need to select 3rd to 5th columns.

  1. Select any cell of the 3rd column.
  2. Use Ctrl + Space shortcut keys from your keyboard to select the column (Leave the keys if the column is selected).
  3. Now use Shift + Right (twice) arrow keys to select the 4th and the 5th column simultaneously.
  4. You could go other way from 5th to 3rd column but you won’t be able to select 3rd and 5th column both, starting from the 4th column as it allows you move or edit in one direction.

Excel Keyboard shortcuts to Select Row

    1. Select the cell, you wish to select.
    2. Press Shift+ Space key to select the row on the selected cell (release the keys, if the row is selected).

  1. If you wish to select the adjacent rows with the selected row, press Shift+ Up/down arrow key(s) to select the UP or DOWN to that row. You can go either way but can’t access both sides of it.

Selecting 3rd to 5th whole rows of the sheet can be done in two ways:

  1. Select any cell of the 3rd row, press Shift + Space key to select the row.
  2. Now use Shift + Down(twice) arrow key to select the 4th and the 5th row.
  3. Or you could go another way from 5th to 3rd row but you won’t be able to select 3rd and 5th row both, starting from the 4th row.

Select multiple rows and columns of a table with shortcut keys and perform your tasks efficiently.

Frequently Asked Question:

Q1. How to apply formula to entire column?

Easy, write a formula in the first cell of column and press CTRL + SPACE to select entire column and then CTRL+D to apply formula to entire column.

Q2. How to select all in excel?

To select all data press CTRL+A.

Q3. How to select multiple cells in Excel mac?

Hold down the command key and scroll over the cells to select. If the cells are not adjacent then click on the cells while holding the command key.

 

Hope you understood how to select columns and rows with shortcuts in Excel. You can perform these tasks in 2013 and 2010. Explore more links on shortcut keys here. If you have any query, please mention in the comment box below. We will help you.

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

Users are saying about us...

  1. Also, you can hold Ctrl and one of the arrow keys to move across an entire range (as long as the row or column are consistent. The marker will stop on an empty cell).
    Naturally, if you add Shift to this it will select the range you move across.

    Ctrl + Shift + Arrow

  2. Instructions make no sense. You say to not release the Shift key, but you never say to push it in the first place.

    “Excel keyboard shortcuts select Column:-

    Select any cell which you want to select
    Press and hold the CTRL key on your keyboard
    Press the space key
    Release the CTRL key and space key and the entire row will be selected
    If you, want to select more than 1 column, don’t release the shift key, use the arrow key to select more than 1 column”

Leave a Reply to Nell Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Categories

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube