| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Highlight cell 1 and move to last cell
I would like to highlight a cell then jump to last entry to highlight
a block so I can copy or delete that block of text. Select all is not what I want. Thanks, Ralphael, the OLD one |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Highlight cell 1 and move to last cell
assume in a single column or row with contiguous data
for a column click in the top cell. Hold down the shift key, then hit the end key followed by the down arrow. for a row, it would be the right arrow. -- Regards, Tom Ogilvy "Ralphael1" wrote: I would like to highlight a cell then jump to last entry to highlight a block so I can copy or delete that block of text. Select all is not what I want. Thanks, Ralphael, the OLD one |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Highlight cell 1 and move to last cell
If cells in a column contain contiguous data:
Click in the topmost cell and double-click the bottom border of the selection box. George Gee "Ralphael1" wrote in message oups.com... I would like to highlight a cell then jump to last entry to highlight a block so I can copy or delete that block of text. Select all is not what I want. Thanks, Ralphael, the OLD one |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Highlight cell 1 and move to last cell
Which jumps to the last cell in the block but does not select the block.
Hold down SHIFT key then follow George's steps or SHIFT + End + DownArrow. Gord Dibben MS Excel MVP On Mon, 19 Feb 2007 19:27:42 -0000, "George Gee" wrote: If cells in a column contain contiguous data: Click in the topmost cell and double-click the bottom border of the selection box. George Gee "Ralphael1" wrote in message roups.com... I would like to highlight a cell then jump to last entry to highlight a block so I can copy or delete that block of text. Select all is not what I want. Thanks, Ralphael, the OLD one |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Highlight cell 1 and move to last cell
Cheers Gord, I missed out that little bit, doh!
George Gee "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Which jumps to the last cell in the block but does not select the block. Hold down SHIFT key then follow George's steps or SHIFT + End + DownArrow. Gord Dibben MS Excel MVP On Mon, 19 Feb 2007 19:27:42 -0000, "George Gee" wrote: If cells in a column contain contiguous data: Click in the topmost cell and double-click the bottom border of the selection box. George Gee "Ralphael1" wrote in message groups.com... I would like to highlight a cell then jump to last entry to highlight a block so I can copy or delete that block of text. Select all is not what I want. Thanks, Ralphael, the OLD one |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hit enter in cell & move text down in cell, not go to cell below. | Excel Worksheet Functions | |||
| Can't highlight a single cell. Creates a range when I move curso | Excel Worksheet Functions | |||
| The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
| Highlight 1 cell in Excel & move mouse-stays highlighted - stop? | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Linear Mode
