|
Die klassischen Dateitypen können ab Januar 2021 nicht mehr verwendet werden. Sie können Ihre klassischen Dateien übertragen oder eine PDF herunterladen. Weitere Informationen

Ability to Lock cells on spreadsheet?

Beantwortet
Demo anfordern

Hi,

I'd like to lock certain columns that I have a vlookup formula on, but I don't see a way to do this. In this example I want to lock columns D and F. Anyone know how I can do this? Thanks!

0

Kommentare

3 Kommentare

Datum Stimmen
  • Matthew Pellerito

    I believe there's ability to lock cells in the top ribbon within the spreadsheet file.  Next to insert, delete, and hide I also have the option to "lock".  I believe this should allow you to lock the entire column, row, or cells.

    0
  • Andrew McKenzie

    In addition, depending on your goals Michelle Haynes you could consider using input mode (if you have access to that feature) to accomplish something similar, albeit somewhat in "reverse" (i.e., allowing changes in specified cells/columns only).

    0
  • Michelle Haynes

    Thank you both Matthew Pellerito and Andrew McKenzie. That worked like a charm! 

    0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.