How to delete many ROWS in EXCEL

[adnanbahrian]

Salam ,

Mara swal yai hay kay , EXCEL ma agar 50,000 rows hon or us ma say agar just row 1 say row 15000 delete karne hon toh kaisay hon gi ?

Thanks.

[Ghayyasg]

Open file
press ctrl g
type A1500 and press enter
select entire row
press ctrl up arrow
now from row 1 to row 1500 is selected.
You can delete it by rite clicking on rows number and select delete.
Thats it.

[Trustamani]

Agree With Ghayyasg

[adnanbahrian]

CTRL + UP ARROW KEY not working in XP 2007 ???

[Ghayyasg]

Phr ap 1500 wali row ko select krain. Aur ctrl +shft +up arrow key use krain. Chek kr k bta raha hn ab.

[adnanbahrian]

now its working , many tks.

[iqbalblti]

now its working , many tks.

bhai thnx kehnay k sath sath on k answr per click kar k thanx karain. haq banta hai hai na????

[riazkhokhar]

nice

[Ghayyasg]

Dua me yad rkhna. Yehe thanx hai apun k liye.

[adnanbahrian]

ok JAZAK ALLAH , aik or question tha .

Excel ma AGAR HIGHLIGHTED / COLORED ROWS KO KAISAY REMOVE KARAYN GAY ?

ASAL MA MARAY PAAS AROUND 50,000 DATA HAY OR MANAY EXCEL MA JO SAME ENTRIES HAYN UNKO HIGHLIGHTED KIA HUWA HAY , AB MA CHAHTA HON KAY JO SAME HAYN WOH SAB REMOVE HO JAYN ,

FOR EXAMPLE :

adnan
adnan
imran

is may adnan same hayn toh ma chahta hon kay adnan dono rows say remove ho jayn.

Thanks.

[Ghayyasg]

thori dair wait karain mere p;ass solution hai mai pesh karta hoon, just ten minutes

[iqbalblti]

ok JAZAK ALLAH , aik or question tha .

Excel ma AGAR HIGHLIGHTED / COLORED ROWS KO KAISAY REMOVE KARAYN GAY ?

ASAL MA MARAY PAAS AROUND 50,000 DATA HAY OR MANAY EXCEL MA JO SAME ENTRIES HAYN UNKO HIGHLIGHTED KIA HUWA HAY , AB MA CHAHTA HON KAY JO SAME HAYN WOH SAB REMOVE HO JAYN ,

FOR EXAMPLE :

adnan
adnan
imran

is may adnan same hayn toh ma chahta hon kay adnan dono rows say remove ho jayn.

Thanks.

simple hai
ctrl+h press karain (office2010/2013)
Find what mai adnan likhain.
Replace ko blank chor dain.
click Replace All.