Results 1 to 6 of 6

Thread: Need Help in Excel?????

  1. #1
    Rahmatullah Ktk's Avatar
    Rahmatullah Ktk is offline Advance Member
    Last Online
    3rd April 2022 @ 12:06 PM
    Join Date
    19 Nov 2009
    Location
    Karak - KPK
    Age
    38
    Gender
    Male
    Posts
    2,725
    Threads
    340
    Credits
    1,352
    Thanked
    146

    Default Need Help in Excel?????

    Assaalm-o-Alaikum Experts,
    Experts, MS Excel me thori help chahiey. Attachment me excel ka aik screen capture diya ha. Mujy pochna ye ha k MS Excel me kam karty hoey jab ham koi list se summary tayar karty hain to is k liey hamain us list me se cells select karni parti ha, agar list choti hoti ha to koi masla nahi, agar list bari ho to hamain ye problem darpish aati ha k ham ne kon kon se list jama ki ha aur kon kon se baqi reh gaee ha. iska aik tariqa to ye ha k ham summary me formula k zariey dikin likin zyada waqt talab ha.
    Kya koi aisa tariqa ha k jab ham koi b cell select karty hian aur wo automaticaly highlight ho jaey takeh hamain isy dobara se select nahi karna paray?
    Please help me, its very good way.
    Thanks
    Attached Images Attached Images  
    اللہ سب سے بڑا ہے۔
    Enjoy Lowest Calls to Pakistan.

  2. #2
    blank is offline Senior Member+
    Last Online
    29th September 2016 @ 07:32 PM
    Join Date
    30 Nov 2010
    Location
    Hyderabad
    Age
    36
    Gender
    Male
    Posts
    385
    Threads
    42
    Credits
    169
    Thanked
    16

    Default

    highlight ho tu jata hy jis ko selcet karte hain uska cell or colm hojta hy

  3. #3
    Tanveer99's Avatar
    Tanveer99 is offline Advance Member
    Last Online
    18th June 2023 @ 02:28 PM
    Join Date
    09 Aug 2009
    Location
    @itdunya.com
    Gender
    Male
    Posts
    762
    Threads
    47
    Credits
    1,590
    Thanked
    178

    Default

    Aap Excel main "Trace Precedents" aur "Trace Dependents" ko use kar kay daikay...
    in commands kay zariye ham apny formula main istamal honay waly Cells ko jan saktay hain....

  4. #4
    Tanveer99's Avatar
    Tanveer99 is offline Advance Member
    Last Online
    18th June 2023 @ 02:28 PM
    Join Date
    09 Aug 2009
    Location
    @itdunya.com
    Gender
    Male
    Posts
    762
    Threads
    47
    Credits
    1,590
    Thanked
    178

    Default

    In commands say aap ko pata chal jaye ga key aap kin kin cells ko
    apnay formula main istimal kar chukay hain....
    Excel 2007 main yeh commands Formula walay Tab main hain...

  5. #5
    Rahmatullah Ktk's Avatar
    Rahmatullah Ktk is offline Advance Member
    Last Online
    3rd April 2022 @ 12:06 PM
    Join Date
    19 Nov 2009
    Location
    Karak - KPK
    Age
    38
    Gender
    Male
    Posts
    2,725
    Threads
    340
    Credits
    1,352
    Thanked
    146

    Default

    Quote tanveer99 said: View Post
    Aap Excel main "Trace Precedents" aur "Trace Dependents" ko use kar kay daikay...
    in commands kay zariye ham apny formula main istamal honay waly Cells ko jan saktay hain....
    Quote tanveer99 said: View Post
    In commands say aap ko pata chal jaye ga key aap kin kin cells ko
    apnay formula main istimal kar chukay hain....
    Excel 2007 main yeh commands Formula walay Tab main hain...
    Salam Tanver Brother,
    Bahot bahot Shukrya, aapne meri bari mushkil hal ki ha.

    Admin, Please Close the Thread.

  6. #6
    Rahmatullah Ktk's Avatar
    Rahmatullah Ktk is offline Advance Member
    Last Online
    3rd April 2022 @ 12:06 PM
    Join Date
    19 Nov 2009
    Location
    Karak - KPK
    Age
    38
    Gender
    Male
    Posts
    2,725
    Threads
    340
    Credits
    1,352
    Thanked
    146

    Default

    Dear Admin, Please Close the Thread!

Similar Threads

  1. Answered MS Word Ki file ko JPG me kesy convert kru?
    By 1heart2pain in forum Ask an Expert
    Replies: 10
    Last Post: 24th May 2010, 02:34 AM
  2. Excel 2003 for Starters: The Missing Manual
    By oralover2006 in forum English IT Zone
    Replies: 2
    Last Post: 28th May 2009, 11:01 AM
  3. MicroSoft Excel short cuts
    By khurshid akhtar in forum General Discussion
    Replies: 1
    Last Post: 17th January 2008, 02:58 PM
  4. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 PM
  5. Excel Shortcut Keys
    By cuticle in forum General Discussion
    Replies: 3
    Last Post: 29th January 2007, 07:45 AM

Bookmarks

Posting Permissions

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