![]() ![]() Now, if I try to type in any cell on the worksheet, I get an error. Re-enter the password and click OK again. To password-protect a worksheet, right-click its tab and click Protect Sheet. To unhide a worksheet, right-click any worksheet tab, click Unhide, and click OK.īy default, all cells on a worksheet are locked.īut, this has no effect until the worksheet is password-protected. To hide a worksheet, right-click the worksheet’s tab, and click Hide. To unhide them, select the column or row on one side of the hidden columns or rows, drag your mouse to the other side, right-click, and click Unhide. ![]() To hide columns or rows, select the columns or rows, right-click them, and click Hide. ![]() You can also lock and password-protect the cells on the worksheet, or even the entire worksheet.īy password protecting the data, only people with the password can make changes.īut it’ll also require a little more effort on your part, if you decide to make changes, because you have to unprotect the data first. You can then unhide them, if you need to make changes. ![]() To prevent anyone from accidentally changing drop-down list data, you can hide the columns, rows, or the entire worksheet that contains the data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |