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.
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.
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.
Agree With Ghayyasg
CTRL + UP ARROW KEY not working in XP 2007 ???
Phr ap 1500 wali row ko select krain. Aur ctrl +shft +up arrow key use krain. Chek kr k bta raha hn ab.
now its working , many tks.
nice
Dua me yad rkhna. Yehe thanx hai apun k liye.
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.
thori dair wait karain mere p;ass solution hai mai pesh karta hoon, just ten minutes
Bookmarks