How to delete data particular range manually

[toravietl]

Hi,

I have excel sheet it contains 200000 records.I want to delete records from 50000 to 200000.Is there any shortcut to delete data.

[abousetta]

Highlight the first row for deletion >> hold down the shift button >> click on the Page Down button until you reach the desired row >> Right click in the highlighted area >> Delete

If you want to delete everything below a certain row:

Highlight the first row for deletion >> hold down the shift button + Ctrl button >> click on the Down Arrow >> Repeat clicking on the Down Arrow until you reach the bottom of the worksheet >> Right click in the highlighted area >> Delete

[samba_ravi]

type A50000 in Name Box and press the enter keys
again type A200000 in Name Box and Press Shift + Enter Keys
now delete the rows