![]() ![]() ![]() In the Changes section, you will find the Protect Sheet option. Go to the Protection tab and check the locked option. Press Ctrl+1 which open Format cells dialogue box. For non-adjacent columns, click on the column letter hold the Ctrl key and click on the column’s heading that you want to protect.Īfter selecting the column, follow the above process.To do so, you have to select the column, hold the shift key and then select the last column. To protect adjacent columns, right-click on the first column’s heading and drag the selection rightwards or leftwards.For protecting the single column, click on the column’s letter and select it.To lock columns in excel, you need to do the following things: Make the column’s selection
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |