Hi: Is there a way to highlight a certain amount of rows with out having to
scroll all the way to the end of an excel sheet? If I want to delete the
remaing rows all the way to the end of the spreadsheet without having to
highlight and scroll down?

Hi
You can use the Name box - just to the left of the formula bar. In there you
could type, for example A2:A65000 (and then Enter) to select all cells
between those entered. You can then hit the delete key to delete the
content.

Andy.

"CP" wrote in message
...
Hi: Is there a way to highlight a certain amount of rows with out having
to
scroll all the way to the end of an excel sheet? If I want to delete the
remaing rows all the way to the end of the spreadsheet without having to
highlight and scroll down?

if you want to delete rows 25 to 100 for example
goto the name box (left end of the formula bar)
and type in 25:100
this will select rows 25 to 100 then <edit<delete

if you want ro delete all of the rows below a given spot say row 101
<edit<go to<special selecy last cell and hit enter

in the name box enter current row number colon 101 hit enter and delte the
hylighted rows.

"CP" wrote:

Hi: Is there a way to highlight a certain amount of rows with out having to
scroll all the way to the end of an excel sheet? If I want to delete the
remaing rows all the way to the end of the spreadsheet without having to
highlight and scroll down?

CP

In addition to the other posts...........

Select row below last data row.

SHIFT + END + Downarrow.

EditDeleteEntire Row.

Make sure you save the workbook at this point.


Gord Dibben Excel MVP

On Mon, 23 May 2005 11:45:19 -0700, "CP" wrote:

Hi: Is there a way to highlight a certain amount of rows with out having to
scroll all the way to the end of an excel sheet? If I want to delete the
remaing rows all the way to the end of the spreadsheet without having to
highlight and scroll down?