I have multipe formulas in rows and columns that I do not want a user to delete. However, I want them to be able to insert rows and columns and have the formual expand it's range to include the new additions.
If I select a range, locked it or hide it, and then protect the worksheet, Excel won't allow me to insert rows or columns. What is the best way of doing this, assuming there is a way.
Thanks
I would have included a sample, I just don't how to do this on this site.
If I select a range, locked it or hide it, and then protect the worksheet, Excel won't allow me to insert rows or columns. What is the best way of doing this, assuming there is a way.
Thanks
I would have included a sample, I just don't how to do this on this site.