Protecting Workbook Structure in Excel

By


In this blog post we will learn to protect the workbook structure in excel. First of all let’s understand what it means by protecting workbook structure.

Once we protect the workbook structure:

1. User cannot insert new worksheet.
2. User cannot delete existing worksheet.
3. User cannot rename worksheet.
5. User cannot change the tab color.

Now, we will see how to protect worksheet structure in excel:

1. Click on “File” option on Ribbon.


2. Click on “Info” option as highlighted in below image.


3. Click on “Protect Workbook” option as highlighted in below image.


4. It will appear further options under “Protect Workbook”. Out of these options we have to click on “Protect Workbook Structure”.


5. Once we click on “Protect Workbook Structure” option, one dialog box will appear on our excel screen as shown in below image. Under this we have to check the checkbox for “Structure” and then enter the password.


6. Once we enter the password and click on “OK” button, we will get one more dialog box to confirm the password. We have to enter the same password which we have entered previously.


7. Once we click on “OK” button then our process to protect the workbook structure is completed.


With this user cannot:

2. Delete existing worksheet.
Microsoft Certified Excel Expert, Enthusiastic to teach excel tricks and basic excel concepts which will help to save time and efforts in our daily office work.

Comments

  1. UnknownJanuary 7, 2023 at 1:06 PM

    Super sir... I am working 8 ys on excel but knowing this ..

    ReplyDelete
    Replies
    1. TejrajJanuary 28, 2023 at 1:45 PM

      Glad to know that you found this article useful.

      Delete

Post a Comment

Related Topics..

Fill Up, Down, Right & Left in Excel

By
Image
Excel has many great tricks which can help us to save our time while working on big data. In this blog post we are going to see one of those tricks where we can fill the data to the upwards of the selected cells, to the downwards of the selected cells, to the right of the selected cells and to the left of the selected cells. There are many situations where we may need to copy the data from selected cell to the upward, downward, left and right cells. But how can we do so?? In excel we can do so with the help of “Fill” command. This command we can found in: Home Tab --> Editing Group --> Fill Command. Let’s take an example. We have inserted a text “Tejraj” in a cell “D5”. Now we will see how to fill this text from cell D5 to Up, Down, Right & Left. Fill Down: 1. Let’s assume that we have to fill the data from cells D5 to D10. For this, select the Cell Range D5:D10. Keep in mind that the data from 1st cell of the selected Cell Range will fill down in entire selection. 2. Select ...
Read more

Select all cells highlighted with specific color at a time

By
Image
Many times we apply colors to cells in excel sheet which will help us to identify important cells just by looking at the data. But what if we use multiple colors to highlight data and later on want to select all the cells which are highlighted with specific color only???  YouTube Video: For example, we have listed some values in excel sheet and highlighted few cells with red color and few cells with yellow color. Now, we want to select all cells which are highlighted with only yellow color at a time. But how????  Don't worry... We will provide you a fantastic solution for this!! Follow below steps:  1. Select entire data. 2. Press Ctrl + F. "Find and Replace" window will appear. 3. Click on Options button. 4. "Find and Replace" window will expand with some additional options. Click on Format button. 5. "Find Format" window will appear. Click on Fill tab and select yellow color. You will s...
Read more

Excel Shortcuts Ctrl A to Ctrl Z

By
Image
Use of keyboard shortcuts while working in excel will be a great help for us. It will save a lot of time. In this post we are going to see Excel Keyboard Shortcuts for alphabets A to Z while using Ctrl key. Below table will give you a brief idea for each shortcut and its functionality: Now, we will see in detail how each of above listed shortcut combinations will work: Ctrl + A :  It will select all content present on the worksheet. If active cell is in the table then it will select entire table. Ctrl + B :  It will convert selected text into Bold . Ctrl + C : It will copy the selected content. The content which is copied can be seen in the Clipboard. Ctrl + D :  It will fill down the content from upper cell. For example we have inserted a number “1” in the cell A1. If we select the cell range from A1:A5 and press Ctrl + D, then this number “1” will automatically fill down in the entire cell range . ...
Read more

Excel Pivot Table

By
Image
Pivot Table in excel is a very powerful feature which helps us to to organize and summarize the data in very effective manner, that too without using any complex excel formula or functions. In this blog post we will see how to create Pivot Table in Excel. Below is the dummy sales data for last three years (2018, 2019 & 2020). In this sales data employees A, B, C & D sales various electronic components like Resistor, Capacitor, Inductor, Diodes & LED in all South, East, North & West region of India. Creating Pivot Table: Now we will see how to create Pivot Table in Excel. Pivot Table feature is available in Insert Tab. Pivot Table command is available in "Insert Tab" under "Tables Group" as shown in below image. Once you click on Pivot Table command, “Create Pivot Table” dialog box will appear on screen. This is like as shown in below image. This “Create Pivot Table” dialog box is very important to create Pivot Table. There are two important options a...
Read more

Title Bar in Excel

By
Image
Title Bar is the bar holding title of the excel file. But apart from showing title, it also contains many other important functionalities. so let's get familiar with Title Bar in this blog post. Title Bar is divided in 03 parts: 1. Quick Access Toolbar 2. File Name 3. Minimize, Maximize/Restore, Close buttons Let’s see in detail about this. Quick Access Toolbar:  The commands which we are using frequently can be added to Quick Access Toolbar. Following steps will help you to add desired commands here. 1. Right click on the desired command. (In below screenshot we have selected “ Format Painter ” as a desired command) 2. Select option “Add to Quick Access Toolbar”. 3. Now, you will see “ Format Painter ” command is added in the Quick Access Toolbar. 4. To remove desired command from Quick Access Toolbar, just right click on the command and then select option “Remove from Quick Access Toolbar”. 5. No...
Read more

Insert Multiple Rows in Excel Based On Cell Value

By
Image
In this blog post we will learn to Insert Multiple Rows in excel based on cell value with the help of VBA Code. For this we have prepared dummy data as shown in below image. In this data we have listed few “Products”, their “Quantities” and their “Unit Price”. Now we want to insert multiple rows based on their “Quantities”. For example, “Product 1” has 04 quantities so we have to add 04 rows below the Product 1, “Product 2” has 02 quantities so we have to add 02 rows below the Product 2 and so on. To avoid wasting our time by manually inserting rows one by one, we can use VBA code which will do our work within seconds. To do this, just follow the below steps: 1. Add “Developer Tab” on the Ribbon if it is not already added. If you are not aware about how to add Developer Tab on the Ribbon then click here . Once added on the Ribbon, “Developer Tab” will looks like as highlighted with red in below image. 2. Now, click on the “Visual Basic” command as highlighted in below image. 3. Once ...
Read more

Data Bars in Conditional Formatting

By
Image
In continuation to series of posts on Conditional Formatting, we will learn how to use Data Bars in Conditional Formatting through this post. Conditional Formatting command can be found in Styles group under Home tab as shown in below image. Click on the Conditional Formatting option and select “Data Bars” option from the list of appeared options. We can now see all the “Data Bar” options available in excel. These “Data Bar” options are categorized into two groups.  1. Solid Fill 2. Gradient Fill: There are six different “Data Bar” colors available in each group. These colors are listed below: 1. Blue Data Bar 2. Green Data Bar 3. Red Data Bar 4. Orange Data Bar 5. Light Blue Data Bar 6. Purple Data Bar Each group with their respective colors are shown in below image: Solid Fill: Gradient Fill: Now we will see how we can apply these “Data Bars” on our data. For this we have created dummy data of few employees and Incentive received by them. Example with Gradient Fill: 1. Select all...
Read more

Insert Shapes in Excel

By
Image
In this blog post we will learn to Insert Shapes in excel. For this we have to click on “Insert” tab and under “Illustrations” group we can find a command “Shapes”.  Once we click on the “Shapes” command, we can see large variety of shapes which are available in excel will appear on our screen. These shapes are divided into 09 different categories: 1. Recently Used Shapes 2. Lines 3. Rectangles 4. Basic Shapes 5. Block Arrows 6. Equation Shapes 7. Flowchart 8. Stars and Banners 9. Callouts Recently Used Shapes : All the recently used shapes will appear in this category. If you are using only few shapes repetitively then you don’t need to search for those shapes in their individual category. You can easily find them in Recently Used Shapes. Lines : We can find various types of Lines, Arrows, and Connectors etc. under this category. Rectangles : We can find various types of Rectangles under this category. Basic Shapes : We can find various types of basic shapes like triangle, oval, ...
Read more

Restrict Cells to Accept Only Decimal Values Using Data Validation

By
Image
In this blog post we will learn to restrict the cells to accept only decimal values with the help of “Data Validation” functionality in excel. For example, we want to ask user to enter only decimal values which are less than 5.00 in cell. If user enters any other value which is greater than 5.00 then the cell should not accept it. For this we will use “Data Validation” functionality in excel. “Data Validation” can be found in “Data” tab under “Data Tools” group. Now let’s see how we can use this “Data Validation” command to restrict cell to accept only decimal values: 1. Select the cells in which we wish to restrict the decimal values. In this case we want to restrict decimal values in cell “B1”. 2. Click on Data Validation command under “Data Tools” group which will appear 03 further options and out of these 03 options again select “Data Validation”. 3. Once we click on “Data Validation” command, one dialog box named as “Data Validation” will appear on screen. 4. Under this dialog box...
Read more

Bold, Italic and Underline Commands from Font Group

By
Image
Bold, Italic and Underline… These three commands are very basic but very important and frequently used in excel. These commands can be found under Font Group. YouTube Video: Let us have detailed description about these commands..!                                              Bold : If we want to change our text into Bold format, then we can use this command. Keyboard shortcut to use this command is Ctrl+B. In below image we have inserted a sample text in cell A1. If we click on the Bold icon from font group or use keyboard shortcut Ctrl+B, then the text from cell A1 will convert into Bold as shown in below image. Italic : If we want to convert our text into Italic format, then we can use this command. Keyboard shortcut to use this command is Ctrl+I. In below image we have inserted a sample text in cell A1. If we click on the Italic icon...
Read more