may nay E/sheet may 1st row may 1 to 99 writ krna ha
or 1st colum may 1 to 9999,plz help me
may nay E/sheet may 1st row may 1 to 99 writ krna ha
or 1st colum may 1 to 9999,plz help me
is thrah 12 numbering lag kar is ko konay say pakar kar nechay drag kar. our yahe formula dosry side par use karain.
AoA!!
Zaara I try lekin yaa tho wahee figure next cell maay paste hojatee haay. e.g i write 1 then in next cell i write 2 then i drag but same figure just paste. Help me in regarding, Thnx
bye
forumala say 12 ko drage kea tu poray kalam mayn 12 12 12 12 12 aya ha,
mayn nay poore sheet pr 01 to 10000 tak counting chata hoon
A2 per 1 likhien aur is k Right Bottom corner per mojod handler ko pakar k neeche ki taraf drag karein sath Ctrl hold kar k rakhein...... 10000 k baad chor dein. Pehle click chorien phir Ctrl.
OR
A2 per 1 likhein
phir A2 ko select karein aur
Edit (menu) > Fill > Series
ko click karien
ab Series dialog box mein
"Series in" mein Columns ko click karien......
Stop Value mein 10000 likhein aur OK ko click kar dein...
Kaho
good Sharing
hmmmmmm Good
Mera Peghaam Mohabbat hai jahan tak pohanchy
Here is another way to do it with formula
a1=1
a2 m ye formula lekhaain
copy down as far as required.Code:=A1+1
Note: oper deye gai drust hain aur easy to use.Mene jo method bataya ha ye sirf is leye ha k excel m aik kam karne k mukhtalif tareqe hain aur agar kisi ko mushkil ho to wo ye istimal kar sakta hai.
Excel 2007 m aap a1 m lekhe howe number ko agar aap neeche drag karain aur mouse release karain ge tu aap notice karain ge ka "+" k neshan k saath drop down k neshan aae ga is ko open karain tu fil aur different option hon ge aap is ko bhe istimal kar sakte hain.
regrads
Bookmarks