+ Reply to Thread
Results 1 to 2 of 2

Protecting or Locking/Unlocking Cells in a Google Sheet

  1. #1
    Registered User
    Join Date
    03-18-2024
    Location
    Southern Maryland
    MS-Off Ver
    Office 365
    Posts
    1

    Exclamation Protecting or Locking/Unlocking Cells in a Google Sheet

    How do i protect cells from input or changes, while leave another cell unlocked for input?
    I see how to do it in desktop Excel, but I do not see this option under the Data tab as a Google Sheet.

    -

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Protecting or Locking/Unlocking Cells in a Google Sheet

    Hi crivera62,

    IF the file is a native Google Sheets file, then you can Protect sheets and ranges

    However, the feature is not available to protect Excel files stored in your Google Drive.

    If that is the case, then you will need to convert the file to a native Google Sheets file, which you can do by going to the menu File > Save as Google Sheets
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA locking and unlocking cells in protected sheet
    By StartingWithExcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2020, 10:26 AM
  2. Replies: 6
    Last Post: 06-19-2017, 02:01 AM
  3. Locking cells and password protecting sheet
    By jax_webs in forum Excel General
    Replies: 5
    Last Post: 11-19-2012, 09:01 AM
  4. Locking excel sheet without unlocking previously locked cells
    By ashileekay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2012, 10:23 AM
  5. Alternative to Locking Cells/Protecting Sheet
    By fiddles in forum Excel General
    Replies: 0
    Last Post: 02-26-2010, 08:08 AM
  6. Locking few cells without Protecting Sheet
    By crapmind in forum Excel General
    Replies: 2
    Last Post: 06-18-2007, 06:48 PM
  7. [SOLVED] Locking Cells ... Without Protecting Sheet
    By monir in forum Excel General
    Replies: 0
    Last Post: 04-04-2006, 01:20 AM

Tags for this Thread

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