• Dp

How To Prevent Users From Deleting Rows and Columns in Excel

In this video tutorial we will see how we can prevent users from deleting rows and columns in Excel Sheet.


This is the smart way of creating the access control on your spreadsheet trackers, reports, dashboards other than the normal routine method of protecting the entire worksheet/spreadsheet.


Let us consider a sample data range like shown below, and let us try to restrict user from deleting any row or column.


Step 1: First, let us select the cells D8 to D16, as shown below.


Step 2: By selecting these cells, type formula as =1 and press Ctrl+Shift+Enter.

You will observe that all the selected cells will have the value as 1, as we have entered an array formula.