When I die, that data dies with me, which is my intention. You could also unhide column B by selecting columns A through C, right-clicking either one of them, and then choosing the Unhide command on the column shortcut menu. This time select AutoFit Column Width. This new tool, which allows you to password-protect ranges of cells, requires a variation on the steps presented earlier in this tip. If so, then you should never use these techniques to protect really private data. The workbook has only a single worksheet, and she needs to protect columns E and J so they cannot be changed, unless the user knows a particular password.
Pressing Ctrl+A will do the trick. Excel displays the Protect Sheet dialog box. Step 4: After you select List, a Source fill box appears. This removes protection from all the cells in the worksheet. You can then click the mouse pointer on any cell in the worksheet to deselect the columns. Excel's freeze panes feature solves this problem by letting you lock specific rows so they're always visible when you scroll.
Copy the column by right clicking and selecting copy. For example, suppose you have a worksheet that contains a column listing employee salaries — you need these figures to calculate the departmental budget figures, but you would prefer to leave sensitive info off most printed reports. To change a row to a specific height, select the row s that you want to change. An option list will pop out, select Format Cells. To change the width of multiple columns, select the columns that you want to change, then drag the right side of one column to its desired width. Protect Cells in Woksheet Step 4: Now, if you want to allow users, to be able to edit some set of cells in a protected sheet then you have to unlock those cells as the password is applied to all the locked cells of the sheet. Step 7: Now, if you want to apply data validation to all the cells below the City cell.
Step 5: A Format Cells dialog box will get opened. For information that is truly private, it has no business in a spreadsheet. Mary Lou wonders if there is a way she can password protect certain columns in a shared workbook. Each cell in the worksheet can be locked or unlocked. How secure is this protection? To make changes, click Unprotect Sheet in the Review Tab you might need a password. Next, drag the boundary below a row to adjust its height.
Additionally, the program selects both the Select Locked Cells and Select Unlocked Cells check boxes in the Allow All Users of This Worksheet To list box below. Excel opens the Protect Structure and Windows dialog box, where the Structure check box is selected and the Windows check box is not. Select Data Validation from the options. If you have provided the password while protecting the sheet, it will ask you for the same password to unprotect the sheet. This protects the cells that are currently selected.
If you want, you can prepare the content of drop-down list in the separate sheet also. There are non-traditional ways you can use, as well. You will see that inside Source box the code for the content is generated. Usually, your intention in protecting a worksheet or an entire workbook is not to prevent all changes but to prevent changes in certain areas of the worksheet. Step 6: Now you can see that the cell you selected in step 1, is converted to a drop-down cell. Excel displays the Format Cells dialog box.
You can tell where the rows were frozen by the green line dividing the frozen rows and the rows below them. All the information in the column disappears from the worksheet. Selecting the Protect Sheet command makes it impossible to make further changes to the contents of any of the locked cells in that worksheet, except for those options that you specifically exempt in the Allow All Users of This Worksheet To list box. Step 5: After you click inside the Source box, select the content of which you want to create a drop-down list. Or The other method to apply data validation to the other cells connected to data validated cell is, select the cells including the data validated cell. By default, Excel selects the Protect Worksheet and Contents of Locked Cells check box at the top of the Protect Sheet dialog box.
Like, you have created an entire years surveillance data of the company and wanted your juniors to mark their remark on it. Click the Select All button the button at the intersection of row numbers and column letters. You are again asked to enter the password. Sometimes you have to share the Excel sheet with some other users also. I have in my possession one of several such modules that are readily available.
Step 3: Time to check your effort. The range now appears in the Allow Users to Edit Ranges dialog box. Excel displays the Format Cells dialog box. Excel again displays the Format Cells dialog box. Then, after unlocking the cells that you still want to be able to change, protect the worksheet as described earlier. The steps will be many, but it does provide for a more flexible way of dealing with the protection issue.
Selecting the Protect Workbook command makes it impossible to make further changes to the layout of the worksheets in that workbook. Select the row right below the row or rows you want to freeze. If you type a password in the Password Optional text box, Excel opens the Confirm Password dialog box. It is easy to select from the list instead of typing in each cell particularly. As you can see in our example, the frozen rows will stay visible when you scroll down. For example, in a budget worksheet, you may want to protect all the cells that contain headings and formulas but allow changes in all the cells where you enter the budgeted amounts. Click the Select All button the button at the intersection of row numbers and column letters.