Highlighting rows or cells

C

CP

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?
 
A

Andy B

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.
 
B

bj

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.
 
G

Gord Dibben

CP

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

Select row below last data row.

SHIFT + END + Downarrow.

Edit>Delete>Entire Row.

Make sure you save the workbook at this point.


Gord Dibben Excel MVP
 
Top