|  | Shift-Ctr-End why not only 1 column? | | |
| | | Al Franz |  |
|  Posted: Tue Jul 22, 2008 11:36 pm Post subject: Shift-Ctr-End why not only 1 column? |  |
Am I not doing this right? When I want to select a range of cells in one
long column (not selecting the whole column), I highlight one cell, press
SHIFT and CTRL and hit the END key. Sometimes it will behave properly and
select all the cells to the end of the spreadsheet in the column or columns
I have highlighted. But other times it seems to select several columns,
more then just the ones I initially highlighted a few rows on, and goes to
the end of the spreadsheet. Anyway to make it just go to the end of the
spreadsheet only highlighting the initial columns one selects? |
| |
| | | OssieMac | |
| | Posted: Wed Jul 23, 2008 12:29 am Post subject: RE: Shift-Ctr-End why not only 1 column? | |
| |  | |
Shift/Ctrl/End takes you to the end of the data in the spreadsheet. Not
reliable though because if you enter data in a cell below the data and then
delete it then it will take you to the last cell that has been used in the
session of the spreadsheet after opening.
Shift/Ctrl/Down Arrow selects the data in a column down to the bottom of the
data. However, if there are any empty cells then it stops at the empty cell.
Right arrow takes you accross.
Ctrl/down arrow takes you down to the next empty cell without selecting all
the data between start and end.
--
Regards,
OssieMac
"Al Franz" wrote:
| Quote: | Am I not doing this right? When I want to select a range of cells in one
long column (not selecting the whole column), I highlight one cell, press
SHIFT and CTRL and hit the END key. Sometimes it will behave properly and
select all the cells to the end of the spreadsheet in the column or columns
I have highlighted. But other times it seems to select several columns,
more then just the ones I initially highlighted a few rows on, and goes to
the end of the spreadsheet. Anyway to make it just go to the end of the
spreadsheet only highlighting the initial columns one selects?
|
|
| |
| | | Paul Hyett | |
| | Posted: Wed Jul 23, 2008 6:51 am Post subject: Re: Shift-Ctr-End why not only 1 column? | |
On Tue, 22 Jul 2008 at 19:29:02, OssieMac
<OssieMac@discussions.microsoft.com> wrote in microsoft.public.excel :
| Quote: |
Shift/Ctrl/Down Arrow selects the data in a column down to the bottom of the
data.
|
I can't believe I never knew about this combo.
Thank you - it will be incredibly useful to me!
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me) |
| |
|
|
