Protect rows from getting deleted September 28, 2020 Toggle navigation MrExcel HomeHere 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, =0, =1, =2, and so on.If someone tries to delete a row, Excel prevents it and shows a cryptic message about arrays, shown below. Share Get link Facebook X Pinterest Email Other Apps Labels Excel Formulas Share Get link Facebook X Pinterest Email Other Apps Comments
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, =0, =1, =2, and so on.If someone tries to delete a row, Excel prevents it and shows a cryptic message about arrays, shown below.
Comments
Post a Comment