Forum Discussion

Marcus_Booth's avatar
Marcus_Booth
Brass Contributor
Jun 24, 2024

Help with best practices for how to protect formulas on table and still expand with new records?

I have several tables, one on each worksheet, that need to be able to expand whenever a user types in a new record (formulas/drop-downs copied to new records).   Apparently, Excel doesn't allow pro...
  • JKPieterse's avatar
    Jun 24, 2024
    You could add a data validation rule to the formula cells. Set it to "Custom" and use this formula:
    FALSE
    That will disallow any entry to those cells. But pasting on top of them will still be possible.

Resources