#Password protect cells in excel 2007 how to#
#Password protect cells in excel 2007 software#
#Password protect cells in excel 2007 password#

With the required cells selected, press Ctrl + 1 to open the Format Cells dialog (or right-click the selected cells and click Format Cells), switch to the Protection tab, and check the Locked checkbox.

#Password protect cells in excel 2007 how to#

For the detailed guidance with screenshots, please see How to lock and hide formulas in Excel. In the Go To Special dialog box, check the Formulas radio button, and click OK. To lock all cells with formulas, go to the Home tab > Editing group > Find & Select > Go To Special. To protect rows in Excel, select them in a similar manner. To select non-adjacent columns, click on the first column's letter, hold down the Ctrl key, and click the headings of other columns you want to protect.Or, select the first column, hold down the Shift key, and select the last column. To select adjacent columns, right click on the first column heading and drag the selection across the column letters rightwards or leftwards.Or, select any cell within the column you want to lock, and press Ctrl + Space. To protect one column, click on the column's letter to select it.To protect columns in Excel, do one of the following: To select non-adjacent cells, select the first cell or a range of cells, press and hold the Ctrl key, and select other cells or ranges. To lock cells or ranges, select them in a usual way by using the mouse or arrow keys in combination with Shift. Select cells, ranges, columns or rows you want to protect. In the Format Cells dialog, switch to the Protection tab, uncheck the Locked option, and click OK.Ģ.Press Ctrl + 1 to open the Format Cells dialog (or right-click any of the selected cells and choose Format Cells from the context menu).Press Ctrl + A or click the Select All button to select the entire sheet.That is why, in order to lock certain cells in Excel, you need to unlock all cells first. Unlock all cells on the sheet.īy default, the Locked option is enabled for all cells on the sheet. The detailed steps to lock cells in Excel 2010, Excel 2013 and Excel 2016 follow below. If you don't want to lock all cells on the sheet, but rather want to protect certain cells from overwriting, deleting or editing, you will need to unlock all cells first, then lock those specific cells, and then protect the sheet. Because the Locked attributed is selected for all cells by default, protecting the sheet automatically locks cells.

Locking all cells on an Excel sheet is easy - you just need to protect the sheet. Find and highlight locked / unlocked cells in Excel.Lock all cells on a sheet except for input cells.How to unlock individual cells on a protected sheet.How to unlock all cells on a sheet (unprotect a sheet).In other words, you may want to only lock a cell or range that shouldn't be changed. Instead, you can lock only specific cells, columns or rows, and leave all other cells unlocked.įor example, you can allow your users to input and edit the source data, but protect cells with formulas that calculate that data. However, in some cases you may not want to go that far and lock the entire sheet. In last week's tutorial, you learned how to protect Excel sheets to prevent accidental or deliberate changes in the sheet contents.

And finally, you will learn how to detect and highlight locked and unlocked cells in Excel. It also shows how to unlock individual cells on a protected sheet by a password, or allow specific users to edit those cells without password.

If my comments have helped please Vote As Helpful.The tutorial explains how to lock a cell or certain cells in Excel to protect them from deleting, overwriting or editing.

You should be able to enter data into all other cells in the Worksheet. If you try to enter info into any of those 3 cells you will not be able to but you will be able to see the formulas there.Ħ. Now to test that it has worked go back to cells D 83 to D 85.

#Password protect cells in excel 2007 password#

Home tab / Cells group / Format / Protect Sheet / Protect Sheet window should launch / put a password of your choice in / hit OK / put password in again / OK.ĥ. Now go back to your Worksheet and highlight cells D83 to D 85 only / Ctrl + 1 again / Custom Lists should launch / go to Protection tab again and place a tick (check) in theĤ. Tab / remove the tick (check) from the Locked field and hit OK.ģ.

#Password protect cells in excel 2007 software#

Ctrl + 1 (at the same time) / Custom Lists pane should launch (sometimes this window has a different name because there is a bug in the software here) / go to the Protection This should highlight the whole Worksheet.Ģ. Go into you Worksheet and click on cell to the left of column A and above the number 1. Take the following actions assuming that the range that you wish to, 'lock' is D 83 to D 85.ġ.