In this tutorial we can learn how to Lock an Hidden Sheet in Excel (Malayalam).In Excel, you can completely hide and protect a worksheet for viewing. If you only hide a sheet without protecting it, users can unhide the sheet and view it. Say you have an Excel file with three sheets (Sheet1, Sheet2, and Sheet3).You can hide Sheet1 by right-clicking it and selecting Hide. As a result, this sheet is hidden, but if you right-click on any of the other sheets’ tabs, you can unhide it by clicking Unhide.
To completely lock a sheet for viewing, follow these steps:
1. Right-click the sheet you want to protect (in this example, Sheet1), and click Hide.
2. Now, protect the workbook. In the Ribbon, go to Review - Protect Workbook.
3. Enter a password, and press OK.
4. Reenter the password to confirm and click OK.
Now, if you try to unhide the sheet, you’ll see that the unhide option is disabled. This means you have completely protected your worksheet from viewing.
#protecthiddensheet #passwordprotectionfrexcelsheet #excelmalayalam
++++++++++++++++++++++
Learn VLOOKUP - • Learn Basic VLOOKUP in...
Learn Pivot Table - • Learn Pivot Table in 1...
Learn How to Build Interactive Dashboard (MIS) - • Build Interactive Dash...
Learn SUMIF Function - • How to Use SUMIFS and ...
Learn How to Create Dropdown List - • Create Data Validation...
Learn VBA Macro - • Learn VBA Macro in 5 M...
++++++++++++++++++++++
Let’s connect on social media:
Facebook: / skill2succced.alfan
LinkedIn: / mohammed-alfan-23a94b30
Instagram: / z_one_clt
Twitter: / toalfan
++++++++++++++++++++++
If you want to find out more about how to learn excel in Malayalam or excel Malayalam tutorial, you must click: www.rowscolumns.com
Download file used in the video: www.rowscolumns.com/free-exce... To learn Excel in English Click on : • FREE Excel Course (Bas...
View my comprehensive courses: laurelss.com/instructor/952 To learn Excel in English Click on: • FREE Excel Course (Bas...
++++++++++++++++++++++
This RU-vid channel is managed by Mohammed Alfan Excel is one of the most widely used and powerful programs in the world. It is used in every sector and industry, from small businesses with only a few employees, to large multinational companies. In this video, Mohammed AlFan, who is a skilled Excel user, shows you how to create a simple, but effective spreadsheet. He goes through many useful tips and tricks that will help you build a successful spreadsheet. learn excel in English by watching this video, as it will teach you how to use the excel program in a short amount of time. People who searched for learn excel in Malayalam likewise searched for excel Malayalam tutorial in on RU-vid, as most professionals are not getting the simple excel tips and tricks through other Channels. Please subscribe to this channel to get the latest updates on excel.
26 май 2022