Cells with formulas

Hi Federica,

The easiest way to do this is not with a formula but to turn on the cell protection/locking.

On the Review Tab click Protect Sheet
Type in a Password
Retype Password
Now try deleting the cells on the page, it should prevent you from doing so.

This uses the default cell status that Excel has and locks all formulas/contents in all cells on that page.

Try that first and see if that's what you were looking to achieve.

To undo, go to the Review Tab, click on Unprotect sheet and type in your password.

Protection is covered on our Excel Intermediate course if you need more advanced functionality.

https://www.stl-training.co.uk/excel-intermediate-courses.php

Kind regards

Richard Bailey
Microsoft Certified Trainer

Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector