|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 12:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com