Highlighting Entire Row without the Mouse

[F. Lawrence Kulchar]

Suppose my cursor is in cell A3...

And I wish to select the entire ROW 3...
Obviously, I can click the mouse over to the left where it says 3 (meaning
the row #)...
Then, the entire row is highlighted!

If, I hold down the 'shift' key, I can move the cursor with the left, right,
up, and down keys any where I want it to go...highlighting all the cells I
pass through...

BUT I DO NOT KNOW HOW TO MOVE TO THE LEFT OF COLUMN 1...i.e. thus
highlighting the entire row without using the mouse??

Can someone please help me?

Thanks,

FLKulchar

 

[aclim]

You can hit ENTER to move to right and SHIFT + ENTER to move to left.
It's this you're mean?

 

[eksh]

shift + space bar

 

[Khoshravan]

use following shortcut keys for selection

To select entire row: Shift+space bar
To select entire column: Ctrl+space bar
To select all cells: Ctrl+Shift+ Spacebar

 

[Suleman Peerzade]

Hi,

You can use Ctrl+Shift+Left key to selet the entire row from A to IV
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade

 

[Suleman Peerzade]

Sorry its not left key but right scroll arrow key.
Ctrl+Shift+right scroll arrow key.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade

 

[Khoshravan]

Be precise. Ctrl+Shift+arrow key does not select all row. It only selects
from active cell until the cell which is not empty.

 

[Suleman Peerzade]

sorry my mistake!!
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade

 

[Francis L. Kulchar]

Does not work...shift enter moves me UP!

 

[Francis L. Kulchar]

THANK YOU!!!!!!!!

Shift plus space bar is the answer!!!!!!

 

[PCLIVE]

Here are some other commands without a mouse that you might find helpful.

Ctrl+Page Up or Page Down Switch between worksheets
Ctrl+Tab Switch between open workbooks
Ctrl+End Quickly get to the last row and column with data
Shift+SpaceBar Select the entire row of the active cell
Ctrl+SpaceBar Select the entire Column of the active cell

Want to select multiple non-adjacent rows?
1) Shift+SpaceBar Selects the entire row of the active cell
2) Shift+F8 Engages "add" mode (visible in the status bar)
3) Use the arrow keys to move to a different row
4) Shift+SpaceBar Selects that entire row

This part is very important.
5) Press Shift+F8 TWICE to re-engage "add" mode

Now just repeat steps 3, 4, and 5 as needed.

Regards,
Paul

--

 

[Francis L. Kulchar]

Thank you,

FLKulchar

--
Francis L. Kulchar

Here are some other commands without a mouse that you might find helpful.

Ctrl+Page Up or Page Down Switch between worksheets
Ctrl+Tab Switch between open workbooks
Ctrl+End Quickly get to the last row and column with data
Shift+SpaceBar Select the entire row of the active cell
Ctrl+SpaceBar Select the entire Column of the active cell

Want to select multiple non-adjacent rows?
1) Shift+SpaceBar Selects the entire row of the active cell
2) Shift+F8 Engages "add" mode (visible in the status bar)
3) Use the arrow keys to move to a different row
4) Shift+SpaceBar Selects that entire row

This part is very important.
5) Press Shift+F8 TWICE to re-engage "add" mode

Now just repeat steps 3, 4, and 5 as needed.

Regards,
Paul