EDUCBA

Home Excel Excel Resources Excel Tips Excel Shortcut to Select Row

Excel Shortcut to Select Row

Excel Shortcut to Select Row 1

Excel Shortcut to Select Row (Table of Content)

Select Row Shortcut in Excel

While working on different types of data where a user is supposed to select any or number of rows multiple times. In that case, it becomes very important for anyone to know the shortcut way to select a row. Knowing some shortcut keys like selecting a row in Excel makes anyone pro in MS Excel and also it is quite helpful for anyone to work in a smarter way. When a person starts performing his/ her work using shortcuts then it automatically improves efficiency and productivity as well. There are different ways to select a row in Excel, which we will be seeing below examples.

How to Select Row Shortcut in Excel?

There are different ways to select a row in MS Excel and moreover, we have shortcut ways as well to do the same task. By selecting a row in excel we can perform a different task as below;

  1. Deletion of any row
  2. Formatting any row
  3. Inserting a new row
  4. Cut the selected row

Once we select any of the rows then we can perform the above-mentioned operations as needed, but limited to the list we just discussed. Any selected row would appear and will get highlighted in grey color as shown below.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

To insert a row using the shortcut key, we need to press Shift + Spacebar together.

Examples

Lets us discuss the examples of Excel Shortcut to Select Row.

You can download this Shortcut to Select Row Excel Template here – Shortcut to Select Row Excel Template

Example #1

In this example, we will see the simple but manual way to select any row. A process that will be discussed is the most traditional and basic method. For this, we have sample data as shown below.

add rows shortcur 1-1

Now to select any row through manual way, we will be using a mouse pointer. So using the mouse pointer first go to the row which we want to select as shown below. Once we put the cursor or any row number, it will get converted into an ARROW shape. Here, we have put the cursor in row 5 as shown below.

add rows shortcur 1-2

Now with the cursor position at row number 5, click LEFT on the mouse button to select the row as shown below. The selected row will then be highlighted in grey color.

add rows shortcur 1-3

Once our target row is selected, we can perform any of the operations like deleting a row, inserting a new row, formatting, etc. as per our choice and requirement.

Example #2

In this example, we will be seeing a shortcut way to select a row. For this, we will be using the same data which we saw in example-1.

add rows shortcur 1-1

This time we will try to select different rows, let say Row number 7. For this, we will put the cursor at row number 7.

excel shortcut 2-1

Now press SHIFT + Spacebar keys together to select the row where we have kept the cursor. The row will be selected with highlighted in grey color as shown below.

excel shortcut 2-2

Once we have selected the required row, we can perform the operations listed at the start of the article using below shortcut keys.

  1. Deletion of any row = CTRL + Minus (“-“)
  2. Formatting any row = CTRL + 1
  3. Inserting a new row = CTRL + SHIFT + Plus (“+”)
  4. Cut the selected row = CTRL + X

While performing any of the above-listed operations we need to press the mentioned shortcut keys together to get the output.

Pros Of Excel Shortcut to Select Row

  1. It saves a lot of time when selecting a row is a regular activity.
  2. Once a row is selected we can start processing other operations and most of the operations which any user performs after selecting a row get executed using the shortcut keys which we have discussed in example-2.
  3. Knowing the shortcut to select a row is a basic thing in excel, which could be easily learned by the above-shown examples.

Cons Of Excel Shortcut to Select Row

  1. Knowing shortcuts for selecting any row is not enough if we are not able to apply the shortcuts shown in example-2 for the further process after selecting a row.

Things To Remember

  1. Although selecting a row using the shortcut and manual ways does not make much difference but when we need to select row/s number of times in a single task then we see the difference.
  2. It is highly important to know and to have hands-on all the shortcuts which we have discussed in example-2, which we are supposed to apply after selecting a row using shortcut keys SHIFT + Spacebar together.
  3. Shortcut keys should be pressed together in one go, instead of pressing it one after another.
  4. There is no other shortcut to select a row other than shown in the examples above.
  5. When we select the row, the select row/s gets highlighted in grey color by default.
  6. When we insert a row by manual or using shortcut keys, new row will be added above the selected row/s.

Recommended Articles

This has been a guide to Excel Shortcut to Select Row. Here we discuss How to Select Shortcut Row in Excel along with practical examples and a downloadable excel templates You can a lso go through our other suggested articles –

  1. Excel Rows and Columns
  2. Add Rows in Excel Shortcut
  3. VBA Insert Row
  4. Excel Freeze Rows
0 Shares
Share
Tweet
Share