Shift+Spacebar Excel Tip How To Select The Entire Row of Excel Worksheet | ExcelTip2Day

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to tell you how to use the shortcut keys:

Shift + Space bar

Let's see more details below.

Tip Quiz

Do you know the shortcut key to edit active cell instantly?

Do you know what to do if you need to select the whole cells in a row?

There are two ways to operate as I am going to tell you now below:

👉 1] To click on the number of any row to be selected.

For example, if we want to select the row no. 5, therefore, hover your mouse over, which are you wanting to and click on it such as the row no. 5 as shown you as the image below.

Figure no.1 Show how to click on a row no.5

Addition: 

If you would like to select for multiple rows. You can move your mouse cursor to click on any number of rows at the farthest left hand as much as you want.

For example, if you want to select the row no. "1" to no. "19", move the mouse cursor and click on the row no. "1" and keep pressing while moving the cursor down until the row no. "19" then, release your mouse.

All the rows between no. "1" and "19" will be selected and indicated with a dim highlight for them as the figure below.

Figure no.2 Show the result of the row selected.

👉 2] To use shortcut key on your keyboard for selecting the entire cells in a row(s) in Excel spreadsheet.

Shortcut for: Selecting the entire row(s) from farthest left to the right side ending edge.

Windows shortcut

ShiftSpace bar

Method as following:

• Move a mouse cursor to any cell in the row(s) that we are going to select them. For example, as the figure below, use a mouse click between the cells B5: B7 

• Then press the two key buttons; [Shift] & [Space Bar] on a keyboard.

Figure no.3 Show how to proceed with the keys Shift + Spacebar.

Okay, done! You should see the entire cells in the row(s) with highlight shown in the figure above.

Tip Answer

 a. Use F2.

 b. It combines between Ctrl + F2.

 c. They are Shift + F3.

 Answer: a. Wow! you made it. 

Source: Shortcut Edit Active Cell And Positions The Insertion Point At The End Of The Data Entered.

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.

I hope to receive any feedback from you guys.

Because they will be such treasures--any error in this blog--for future improvement.

Thanks for reading.

Bye,

Posted by: Michael Leng



I've known, then I've grown.
See more articles:

• Function [Home] Excel Keyboard Key | X'cel
• [Page Down] Microsoft Excel Keyboard Shortcut Button And Method
• Turn Off / Turn On Scroll Lock Excel Tip To Lock & Unlock On Keyboard