| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting Entire Row without the Mouse
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlighting Entire Row without the Mouse
You can hit ENTER to move to right and SHIFT + ENTER to move to left.
It's this you're mean? -- Aclim "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlighting Entire Row without the Mouse
Does not work...shift enter moves me UP!
-- Francis L. Kulchar "aclim" wrote in message ... You can hit ENTER to move to right and SHIFT + ENTER to move to left. It's this you're mean? -- Aclim "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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlighting Entire Row without the Mouse
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlighting Entire Row without the Mouse
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlighting Entire Row without the Mouse
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlighting Entire Row without the Mouse
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 "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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlighting Entire Row without the Mouse
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 "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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlighting Entire Row without the Mouse
Sorry its not left key but right scroll arrow key.
Ctrl+Shift+right scroll arrow key. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Suleman Peerzade" wrote: 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 "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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlighting Entire Row without the Mouse
Be precise. Ctrl+Shift+arrow key does not select all row. It only selects
from active cell until the cell which is not empty. -- R. Khoshravan Please click "Yes" if it is helpful. "Suleman Peerzade" wrote: Sorry its not left key but right scroll arrow key. Ctrl+Shift+right scroll arrow key. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Suleman Peerzade" wrote: 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 "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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlighting Entire Row without the Mouse
sorry my mistake!!
-- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Khoshravan" wrote: Be precise. Ctrl+Shift+arrow key does not select all row. It only selects from active cell until the cell which is not empty. -- R. Khoshravan Please click "Yes" if it is helpful. "Suleman Peerzade" wrote: Sorry its not left key but right scroll arrow key. Ctrl+Shift+right scroll arrow key. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Suleman Peerzade" wrote: 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 "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
