Results 1 to 8 of 8

Thread: Excel Sheet (Column Protect )

  1. #1
    Refan's Avatar
    Refan is offline Advance Member
    Last Online
    22nd October 2024 @ 11:55 AM
    Join Date
    14 Jul 2008
    Location
    Karachi - Pakis
    Age
    35
    Posts
    2,301
    Threads
    564
    Credits
    3,137
    Thanked
    147

    Default Excel Sheet (Column Protect )

    اسلام علیکم.. ..
    اُمید ہے سب بخیر ہونگے... جناب میں کافی دنوں بعد آیا ہو ایک پروپلم ہوگئی ہے.. مجھ سے ایکسل کی شیٹ کے کالم میں بلاک ہوگیا ہے.. اُس کا انبلاک کیسے کیا جائے... تصویر نیچجے دی ہے میں نے پلیز ارجنٹ حل کیا جائے اس مسئلے کو..
    شکریہ..
    Attached Images Attached Images  
    Last edited by Refan; 28th December 2013 at 10:05 AM. Reason: photo attached

  2. #2
    Sahil_Jaan's Avatar
    Sahil_Jaan is offline V.I.P
    Last Online
    13th April 2024 @ 08:40 PM
    Join Date
    05 Jan 2008
    Gender
    Male
    Posts
    14,710
    Threads
    673
    Credits
    11,234
    Thanked
    1925

    Default

    اس طرح کچھ نہیں ہو سکتا فئل اپلوڈ کریں میں چیک کرتا ہوں کہ یہ کیسے انلا ک ہو گا

  3. #3
    imranjhang's Avatar
    imranjhang is offline Senior Member+
    Last Online
    11th May 2021 @ 02:36 PM
    Join Date
    17 Dec 2009
    Age
    39
    Posts
    94
    Threads
    1
    Credits
    1,390
    Thanked
    13

    Default

    Alt, T, P, P

  4. #4
    Refan's Avatar
    Refan is offline Advance Member
    Last Online
    22nd October 2024 @ 11:55 AM
    Join Date
    14 Jul 2008
    Location
    Karachi - Pakis
    Age
    35
    Posts
    2,301
    Threads
    564
    Credits
    3,137
    Thanked
    147

    Default

    Alt, T,P,P kya hai

  5. #5
    imranjhang's Avatar
    imranjhang is offline Senior Member+
    Last Online
    11th May 2021 @ 02:36 PM
    Join Date
    17 Dec 2009
    Age
    39
    Posts
    94
    Threads
    1
    Credits
    1,390
    Thanked
    13

    Default

    Quote Refan said: View Post
    Alt, T,P,P kya hai
    Worksheet main kisi bhi cell ko select karain... aur phir apnay keyboard se
    yeh keys press karain:
    Alt, T, P, P
    yeh Sheet ko unprotect karnay ka shortcut hai

  6. #6
    Refan's Avatar
    Refan is offline Advance Member
    Last Online
    22nd October 2024 @ 11:55 AM
    Join Date
    14 Jul 2008
    Location
    Karachi - Pakis
    Age
    35
    Posts
    2,301
    Threads
    564
    Credits
    3,137
    Thanked
    147

    Default

    main try kar choka hn.. nahi horha please... print screen agar dekha dain

  7. #7
    imranjhang's Avatar
    imranjhang is offline Senior Member+
    Last Online
    11th May 2021 @ 02:36 PM
    Join Date
    17 Dec 2009
    Age
    39
    Posts
    94
    Threads
    1
    Credits
    1,390
    Thanked
    13

    Default

    yar waisay to koi masla nahi, ap pehlay Alt key press karain phir T aur us kay baad P (2 baar).

    ap excel ki help main "Unprotect Sheet" ko search kar lain.. meray pas office 2010 hai is liye 2007 ribbon main mojood command ka screen shot nahi day sakta.. office 2010 main yeh info File -> Info -> Protect Workbook -> Protect current sheet main hai... Office 2007 main shahid office menu main he ho ap check kar lain.

  8. #8
    Refan's Avatar
    Refan is offline Advance Member
    Last Online
    22nd October 2024 @ 11:55 AM
    Join Date
    14 Jul 2008
    Location
    Karachi - Pakis
    Age
    35
    Posts
    2,301
    Threads
    564
    Credits
    3,137
    Thanked
    147

    Default

    let me check.

Similar Threads

  1. Bank Balance Sheet (Excel Prob)
    By Adeawan in forum Ask an Expert
    Replies: 14
    Last Post: 2nd October 2016, 05:04 PM
  2. Solved Excel Sheet Formula
    By Shireen Shari in forum Solved Problems (IT)
    Replies: 44
    Last Post: 1st June 2012, 09:36 PM
  3. How to protect excel sheet from viewing
    By majid_1star in forum Ask an Expert
    Replies: 1
    Last Post: 30th November 2011, 01:03 PM
  4. Solved Excel Sheet Problem ???
    By Baazigar in forum Solved Problems (IT)
    Replies: 8
    Last Post: 28th July 2011, 09:11 PM
  5. Replies: 1
    Last Post: 27th January 2010, 10:03 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
  •