There is another way of protecting cells, rows, and columns of excel using the VBA code. If you don’t want to give any password while protecting a sheet it`s completely your choice. Note that Password protects your sheet effectively. Unlocking the rows and columns of excel follows the same rule. Enter the password that you gave while protecting the cells. Just click on the Review option on top, click on the Unprotect Sheet. Unlocking the cells in excel is much easier. The rest procedure is the same as before. By clicking them on we can select the entire row or column. For columns a downward arrow and for the row, a rightward arrow will come up. For locking rows and columns just move the mouse courser to the row heading or column heading. ![]()
0 Comments
Leave a Reply. |