Page 1 of 2 12 LastLast
Results 1 to 12 of 20

Thread: Cell lock

  1. #1
    janibaba's Avatar
    janibaba is offline Senior Member+
    Last Online
    28th August 2017 @ 10:42 AM
    Join Date
    11 Mar 2009
    Age
    41
    Posts
    534
    Threads
    37
    Credits
    1,030
    Thanked
    7

    Default Cell lock

    Dear Seniours,


    Dear excell 2003 me kisi column ko protect / lock krna ho to kese kia jaiga plz batain

    mtlb hum kisi column me formula lgate hain hum chahte hain ke jo koi sheet use kre wo beshk koi b figer entry kre ho jai mgr totaling wale me hamara formula lga hwa ho ose koi changing na kr ske plz jtni jaldi ho batain......

  2. #2
    Join Date
    16 Jul 2009
    Location
    (¯`·._.•!TD•._.·´¯)*(¯`·._.•HUJRÕ._.·´¯)
    Posts
    2,452
    Threads
    214
    Credits
    39
    Thanked
    84

    Default

    Bhai mere, istarah nahi hosakta, agar aap Protect karogay to poora workbook protect hoga, naa k sirf ek coloumn or cell.

  3. #3
    janibaba's Avatar
    janibaba is offline Senior Member+
    Last Online
    28th August 2017 @ 10:42 AM
    Join Date
    11 Mar 2009
    Age
    41
    Posts
    534
    Threads
    37
    Credits
    1,030
    Thanked
    7

    Default

    g bhai ap ne theek kaha protect krne se puri sheet protect ho jati hay me chahta hu sif ek column ho, ko to hal hoga

  4. #4
    E-KEY is offline Member
    Last Online
    6th January 2017 @ 08:45 PM
    Join Date
    06 Aug 2009
    Posts
    113
    Threads
    5
    Thanked
    3

    Default

    Aik column ya cell kabhi nhi ho sakta

  5. #5
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    There are many ways to do this. But 1st try this.

    1. Select your entire range including your formula's column.
    2. goto Format ->cell ,under protection tab uncheck locked box
    3.press F5 key, select special and click on formula radio button.
    4.goto Format ->cell ,under protection tab check locked box
    5. tool->protection--> k tab m sheet protct select karain aur password laga lain.

    you will notice k sirf wohe column/range jin m formula ha lock ho jain ge.

    tmay be this will help you.

    regards

  6. #6
    Shehzad Iqbal's Avatar
    Shehzad Iqbal is offline Advance Member+
    Last Online
    26th November 2023 @ 06:28 PM
    Join Date
    16 Jan 2009
    Location
    Karachi
    Gender
    Male
    Posts
    28,463
    Threads
    2271
    Credits
    11,705
    Thanked
    5385

    Default

    Quote janibaba said: View Post
    dear seniours,
    salam::

    Dear excell 2003 me kisi column ko protect / lock krna ho to kese kia jaiga plz batain

    mtlb hum kisi column me formula lgate hain hum chahte hain ke jo koi sheet use kre wo beshk koi b figer entry kre ho jai mgr totaling wale me hamara formula lga hwa ho ose koi changing na kr ske plz jtni jaldi ho batain......
    جی سیار بھائی نے درست کہا ہے ۔
    آپ مطلوبہ رینج لاک کر سکتے ہو۔ لاک سے مراد اس میں کوئی ایڈیٹنگ نہیں کرسکتا ہے۔

  7. #7
    John_Cena is offline Member
    Last Online
    7th January 2011 @ 07:36 PM
    Join Date
    09 Apr 2010
    Posts
    38
    Threads
    0
    Thanked
    0

    Default

    very nice

  8. #8
    decent_soldiers's Avatar
    decent_soldiers is offline Advance Member
    Last Online
    3rd March 2022 @ 12:16 PM
    Join Date
    22 Sep 2008
    Location
    Islamabad
    Gender
    Male
    Posts
    906
    Threads
    89
    Credits
    1,138
    Thanked
    29

    Default

    bROTHER, IS KO AP AAE main post karty...

  9. #9
    Ganxtr's Avatar
    Ganxtr is offline Advance Member
    Last Online
    5th July 2019 @ 09:15 AM
    Join Date
    15 Nov 2009
    Location
    CRIME CITY
    Posts
    1,740
    Threads
    18
    Credits
    83
    Thanked
    100

    Default

    Ok try it

  10. #10
    winxp's Avatar
    winxp is offline Senior Member+
    Last Online
    22nd September 2019 @ 08:50 PM
    Join Date
    16 Apr 2010
    Location
    Peshawar- KPK
    Gender
    Male
    Posts
    126
    Threads
    28
    Credits
    7
    Thanked
    7

    Default

    A cell can also be protected by the below procedure:
    1- Selcect entire sheet
    2- Go to format
    3- click cell
    4- Then jump to protection tab button
    5- un chek protection button click ok
    6- select the cell/cells to be protected.
    7- go to tools, select protection and ok

  11. #11
    afzaldir's Avatar
    afzaldir is offline Senior Member+
    Last Online
    25th May 2020 @ 10:47 PM
    Join Date
    31 Jul 2010
    Location
    Gujranwala
    Age
    40
    Gender
    Male
    Posts
    215
    Threads
    3
    Credits
    7
    Thanked
    10

    Default

    Yes ap kar sakte ho sirf neeche diye steps ko follow karo:
    sub se pehle pori Sheet ko select karo (Ctrl+A)
    Ctrl+1 press karo aur Protection (tab) per jao.
    "Locked" ki option ko uncheck kar do. > OK
    Ab wo column select karein jis ko lock lagana hey.
    Select karne k baad Ctrl+1 aur Protection (tab) per jao.
    "Locked" ki option ko check kar do.
    Ab
    Tools(menu) > Protection > Protect Sheet
    "Select Locked Cells" ko uncheck kar dein.

    Kaho

  12. #12
    *Tamraiz*'s Avatar
    *Tamraiz* is offline Advance Member+
    Last Online
    29th August 2022 @ 08:08 AM
    Join Date
    26 Nov 2010
    Location
    Sialkot
    Gender
    Male
    Posts
    16,583
    Threads
    1051
    Credits
    1,207
    Thanked
    1738

    Default

    Nice

Page 1 of 2 12 LastLast

Similar Threads

  1. upload photo from pc to cell n cell to pc
    By sizs in forum Ask an Expert
    Replies: 3
    Last Post: 21st July 2015, 01:17 PM
  2. how to play song during call in cell phone for andriod cell??
    By ShanPasha1 in forum Mobile phones problems and Help Zone
    Replies: 3
    Last Post: 1st July 2014, 04:32 PM
  3. Num Lock, Caps Lock, Scroll Lock Alarm(Screen shading)
    By H.B.K in forum Tips and Tricks
    Replies: 9
    Last Post: 31st March 2014, 07:46 PM
  4. Folder lock for java cell phones
    By smartyounus in forum General Mobile Discussion
    Replies: 163
    Last Post: 2nd April 2012, 01:59 PM

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
  •