Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
scrolling and highlighting without touching mouse buttons | Excel Discussion (Misc queries) | |||
Highlighting Entire Row using CF | Excel Worksheet Functions | |||
Highlighting cells - Mouse sticking?? | Excel Discussion (Misc queries) | |||
Mouse highlighting cells error | Excel Discussion (Misc queries) | |||
How do I stop mouse from highlighting cells automatically | Excel Discussion (Misc queries) |