LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default Highlighting Entire Row without the Mouse

Thank you,

FLKulchar

--
Francis L. Kulchar
"PCLIVE" wrote in message
...
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" wrote in message
...
THANK YOU!!!!!!!!

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

--
Francis L. Kulchar
"eksh" wrote in message
...
shift + space bar

"F. Lawrence Kulchar" wrote:

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







 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
scrolling and highlighting without touching mouse buttons Pete Excel Discussion (Misc queries) 1 April 2nd 08 12:27 AM
Highlighting Entire Row using CF davisk Excel Worksheet Functions 3 November 14th 07 07:05 AM
Highlighting cells - Mouse sticking?? jeng6109 Excel Discussion (Misc queries) 2 June 23rd 07 12:46 AM
Mouse highlighting cells error Kevin M Excel Discussion (Misc queries) 0 May 11th 06 09:02 PM
How do I stop mouse from highlighting cells automatically Tibber60 Excel Discussion (Misc queries) 0 April 24th 06 02:39 PM


All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"