You can see now that Sheet 1 has been hidden as the tab is no longer available. To hide a worksheet in Excel, Select the worksheet and right-click. However, very hidden sheets also pose a threat as they can these sheets can be used to hide data or formulas whose purpose is of fraudulent nature. In cases like this, the use of very hidden sheets comes invaluable. Adding password protection also has its limitations as it can lock other functionalities, we might not want to be locked. But that is by no means foolproof, as most users know how to unhide a sheet if they really wanted too. By hiding a sheet with important formulas, a user would have to go out of their way to unhide the sheet to edit or delete the formula. Hidden sheets are common in large workbooks. However, what many are not aware of is that Excel also offers the ability to set sheets as very hidden. Hidden and Very Hidden Sheets in Excel – Skip to VideoĪs most of us know, Excel, being such an amazing tool, gives us the ability to Hide sheets from view.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |