+ Reply to Thread
Results 1 to 2 of 2

To Protect Excel documents and allowing only few cells to edit

Hybrid View

  1. #1
    DHANRAJ
    Guest

    To Protect Excel documents and allowing only few cells to edit

    I would like to Protect a Excel Sheet leaving only few rows for editing(data
    entry) purpose how this can be done. If I give protect sheet the whole
    document is protected and I am unable to edit.

  2. #2
    Bondi
    Guest

    Re: To Protect Excel documents and allowing only few cells to edit

    Hi Dhanraj,

    Select the rows you want to enter data into. Right click and choose
    Format Cells ->Protection. Then uncheck Locked. Then go to Tools ->
    Proctecion -> Protect Sheet and accept default.

    Best regards,
    Bondi


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1