Highlighting Entire Row without the Mouse

  • Thread starter Thread starter F. Lawrence Kulchar
  • Start date Start date
F

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
 
You can hit ENTER to move to right and SHIFT + ENTER to move to left.
It's this you're mean?
 
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
 
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
 
Sorry its not left key but right scroll arrow key.
Ctrl+Shift+right scroll arrow key.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade
 
Be precise. Ctrl+Shift+arrow key does not select all row. It only selects
from active cell until the cell which is not empty.
 
sorry my mistake!!
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade
 
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

--
 
Thank you,

FLKulchar

--
Francis L. Kulchar
PCLIVE said:
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
Click to expand...
 
Back
Top