Excel 2019: Protect Rows with an Array Formula
July 31, 2019 - by Bill Jelen
Here is an odd use for an array formula: Say that you don‘t want anyone to delete or insert any rows in one section of a worksheet. Scroll far to the right, off the screen, and build an array in those rows. Select Z1:Z9. Type
=2 and press Ctrl+Shift+Enter. You can use any number,
=2, and so on.
If someone tries to delete a row, Excel prevents it and shows a cryptic message about arrays, shown below.
Title Photo: Jon Moore at Unsplash.com