Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

If my worksheet is protected, how can i give some editing privileges in specific range of cells to other users so they can edit and add data?

user-image
Question ajoutée par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date de publication: 2015/06/09
Marius Burger
par Marius Burger , Chief Financial Officer (cfo) , MTN Namibia

You just unlock the ranges that he is allowed to edit in the worksheet before you lock the worksheet. select the ranges of cells -- format cells--- Protection---remove the tick at "lock". Then after locking the sheet, this specified/selected cells can still be modified

Mohammad Basheer abu ahmad
par Mohammad Basheer abu ahmad , مشرف كمبيوتر ، الإشراف على الموظفين , قطاع عام

You can determining the data - cells and rows - to any client , sharing it by giving privilege to read, write or edit for specific data

PANGERWAR PAVAN KISHOR
par PANGERWAR PAVAN KISHOR , HSE- Officer , Greenko Energy Projects Pvt. Ltd.

  1. If the worksheet is protected, do the following:

    1. On the Review tab, in the Changes group, click Unprotect Sheet.

      Unprotect Sheet 

      The Protect Sheet command changes to Unprotect Sheet when a worksheet is protected.

    2. If prompted, type the password to unprotect the worksheet.

  2. Select the whole worksheet by clicking the Select All button.

    Select All button

  3. On the Home tab, in the Font group, click the Format Cell Font dialog box launcher. You can also press Ctrl+Shift+F or Ctrl+1.

    Format Cells dialog box launcher

    The Format Cells dialog box appears.

  4. On the Protection tab, clear the Locked box and then click OK.

    This unlocks all the cells on the worksheet when you protect the worksheet. Now, you can choose the cells you specifically want to lock.

  5. On the worksheet, select just the cells that you want to lock.

  6. Bring up the Format Cells dialog box again (Ctrl+Shift+F).

  7. This time, on the Protection tab, select the Locked box and then click OK.

  8. On the Review tab, in the Changes group, click Protect Sheet.

    Protect Sheet

  9. In the Allow all users of this worksheet to list, select the elements that you want users to be able to change.

    More information about worksheet elements

    Worksheet elements

    Clear this check box

    To prevent users from

    Select locked cells

    Moving the pointer to cells for which the Locked check box is selected on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells.

    Select unlocked cells

    Moving the pointer to cells for which the Locked check box is cleared on the Protection tab of the Format Cells dialog box. By default, users can select unlocked cells, and they can press the TAB key to move between the unlocked cells on a protected worksheet.

    Format cells

    Changing any of the options in the Format Cells or Conditional Formatting dialog boxes. If you applied conditional formats before you protected the worksheet, the formatting continues to change when a user enters a value that satisfies a different condition.

    Format columns

    Using any of the column formatting commands, including changing column width or hiding columns (Home tab, Cells group, Format button).

    Format rows

    Using any of the row formatting commands, including changing row height or hiding rows (Home tab, Cells group, Format button).

    Insert columns

    Inserting columns.

    Insert rows

    Inserting rows.

    Insert hyperlinks

    Inserting new hyperlinks, even in unlocked cells.

    Delete columns

    Deleting columns.

    If Delete columns is protected and Insert columns is not also protected, a user can insert columns that he or she cannot delete.

    Delete rows

    Deleting rows.

    If Delete rows is protected and Insert rows is not also protected, a user can insert rows that he or she cannot delete.

    Sort

    Using any commands to sort data (Data tab, Sort & Filter group).

    Users can't sort ranges that contain locked cells on a protected worksheet, regardless of this setting.

    Use AutoFilter

    Using the drop-down arrows to change the filter on ranges when AutoFilters are applied.

    Users cannot apply or remove AutoFilters on a protected worksheet, regardless of this setting.

    Use PivotTable reports

    Formatting, changing the layout, refreshing, or otherwise modifying PivotTable reports, or creating new reports.

    Edit objects

    Doing the any of the following:

    • Making changes to graphic objects including maps, embedded charts, shapes, text boxes, and controls that you did not unlock before you protected the worksheet. For example, if a worksheet has a button that runs a macro, you can click the button to run the macro, but you cannot delete the button.

    • Making any changes, such as formatting, to an embedded chart. The chart continues to be updated when you change its source data.

    • Adding or editing comments.

    Edit scenarios

    Viewing scenarios that you have hidden, making changes to scenarios that you have prevented changes to, and deleting these scenarios. Users can change the values in the changing cells, if the cells are not protected, and add new scenarios.

Kim Sollano
par Kim Sollano , DOCUMENT CONTROL MANAGEMENT/GENERAL ELECTRONICS ENGINEER/(COMPANY FIRST AIDER) , ADNOC / SHELL (BGD) BAB GAS DEVELOPMENT PROJECT

On MS Word Documents

1. Go to FILES choose OPTIONS  then a window will appear,

2. click on Customize Ribbon and on the Right drag down selection Check the DEVELOPER under "Main Tabs" then click ok.

 

The next time you select a cell with an option the developer tab will appear and you will be able to remove the edit protection of the file.

Shahzad Hameed
par Shahzad Hameed , Sr. Quantity Surveyor , Al Arrab Contracting Company

You just unlock the ranges that he is allowed to edit in the worksheet before you lock the worksheet. select the ranges of cells -- format cells--- Protection---remove the tick at "lock". Then after locking the sheet, this specified/selected cells can still be modified

muddassar  manzoor
par muddassar manzoor , Associate Practice Manager , Obox Solution Pvt Ltd

1.Open spreadsheet in Google sheet

2.Click data,protect sheet and range

3.Click add a sheet or range

4.To protact range

5.Click permission or change permission

6.Choose how you want to limit ediiting

7.Click save or Done

SUFAID HUSSAIN
par SUFAID HUSSAIN , Senior Accountant , Binkhamis International Trading Company

After Selecting Unprotect Option - Enter Your Password - then select the Home - Select Alignment - Select Protuction - Remove Tik From Locked.

Syed Asif Ahmed
par Syed Asif Ahmed , Manager Business Development , Global Logistics DWC LLC

The review tab change the group, click unprotect sheet.

shaik mahammad ali ali
par shaik mahammad ali ali , Electrical Inspector , rowad al jazeera

Select the cells or ranges you want to unlock by a password when the sheet is protected.

Go to the Review tab,Changes group, and click Allow Users to Edit Ranges.

Nazar Abbas
par Nazar Abbas , Accountant , Strong Rent A Car

Just unlock from the below sheet number and also enter its password for unlocking then it will be easily edited

Noufal Noushad
par Noufal Noushad , Clerk , Vectrus

Customize the range of protecting area .can give the permission to customise remaining area 

More Questions Like This