Microsoft Excel

Inserting Rows & Columns In Protected Worksheet (Excel)

In order to allow for inserting columns and/or rows in a protected worksheet you start by knowing how to lock and unlock fields. To lock/unlock a cell, right-click a cell and choose “Format Cells”. Go to the “Protection” tab. To lock the field so that the end-user cannot enter data into that cell, make sure… Continue reading Inserting Rows & Columns In Protected Worksheet (Excel)