# Thread: Problem In Ms Excel

1. Senior Member+
Last Online
24th December 2018 @ 07:39 AM
Join Date
03 Feb 2013
Location
Karachi
Gender
Male
Posts
173
18
Credits
1
Thanked
6

## Problem In Ms Excel

Salam mein aaj excel pe kam kar raha tha lekin 1 masla a gaya masla yeh k
mein jab range k total ko copy karta hun to range bhi move ho jati hai plz iska koi hal bata den apki asani k liye mein screen shot bhi diye hein

http://www.mediafire.com/view/2tsh0w1db6mmpck/Excel.avi
Last edited by iamaraza; 10th December 2013 at 06:52 AM.

Last Online
22nd March 2019 @ 01:30 PM
Join Date
31 Jul 2009
Location
Nowshera(KP)
Age
42
Gender
Male
Posts
833
9
Credits
227
Thanked
340
iamaraza said:
Salam mein aaj excel pe kam kar raha tha lekin 1 masla a gaya masla yeh k
mein jab range k total ko copy karta hun to range bhi move ho jati hai plz iska koi hal bata den apki asani k liye mein screen shot bhi diye hein
Walikum

Jab aap ranges ko excel m copy kr k paste krte hain tu excel automatically references copy kr leta ha is ko relatives reference kaha jata ha. jese aap k case m ha. agar tu aap ka data k same layout ha tu ya beneficiant hota ha lkn aap k case m asa nahee. Aap ki ranges m data aik jasa nahee is leye aap ko formula manual lekhan ho ga.

lkn agar aap ranges ka total copy krna chahte hian tu try make ranges absolute by pressing F4 when moving around ranges. phr jab aap copy kariange formula ko tu use range ka total ya formula copy ho ga jo pahli range ka total dekhai ga.

regards,

3. Senior Member+
Last Online
24th December 2018 @ 07:39 AM
Join Date
03 Feb 2013
Location
Karachi
Gender
Male
Posts
173
18
Credits
1
Thanked
6
Apne Solution Nahi bataya

Last Online
22nd March 2019 @ 01:30 PM
Join Date
31 Jul 2009
Location
Nowshera(KP)
Age
42
Gender
Male
Posts
833
9
Credits
227
Thanked
340
iamaraza said:
Apne Solution Nahi bataya
jesa aap chahte ho mere ilam k mutabiq wesa nahee ho skata except k jab aap ki ranges same na hon. agar aap apna masla zara mazed explain karain tu bahtar ho ga. ya apne sheet attached kr dian.

agar aap n sirf total copy krna ha ya sirf total chahte hain tu sirf "=" k sign k sath cell reference de dain.

for example as per your screen shot your first total is in H8. agar aap iske total ko dosre screen shot k mutabiq I9 m chahte hain tu try simple in I9

=H8

regards

5. اس فائل پر چیک کریں

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•