To make it easier to move through editable ranges, you can also disable the user's ability to select cells within the locked portion of the worksheet. Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.Įxcel allows you to grant permissions to specific users and user groups to modify selected ranges within a protected worksheet. NOTE: This method allows all users to edit the range. In Excel 2003 or in Excel 2002, on the Format menu, click Cells, and then click the Protection tab.Ĭlick to clear the Locked check box, and then click OK.Ĭlick Protect Sheet, click to clear the Select Locked Cells check box, and then click OK. In Excel 2007, click the Home tab, click Format in the Cells group, click Format Cells, and then click the Protection tab. Right, Click, and select Format Cells from the options that appeared in the context menu. The steps to unlock all the cells are as follows: Press Ctrl+A to select the entire worksheet.
Highlight locked cells excel how to#
So let us see how to unlock all the cells. As we need to lock particular cells in the workbook, it is necessary to unlock all the cells. Tab key should now tab to only editable cells. The cells in excel are protected and locked in excel. Then go to Review tab, set cells that you want users to edit, and Protect Sheet.
Next highlight cells you want locked, Format Cells - Protection, select Locked box. Unlock the cells to provide access to a range of cells instead of clicking to select the Allow Users to Edit Rangescheck box. Select all and under Format Cells - Protection, unselect Locked box. In Microsoft Office Excel 2003 or in Microsoft Excel 2002, on the Tools menu, click Protection, and then click Allow Users to Edit Ranges.Ĭlick Protect Sheet, leave the Select Locked Cells check box selected, and then click OK. In Microsoft Office Excel 2007, click the Review tab, and then click Allow Users to Edit Ranges in the Start Excel, open your workbook, and then select the range that you want to allow access to. 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). To work around this issue, use one of the following methods:ĭo not clear the Select Locked Cells check box when you protect a worksheet: Press Ctrl + A or click the Select All button to select the entire sheet.
This behavior occurs when you click to clear the Select Locked Cells check box (in the Protect Sheet dialog box) to prevent users from selecting any cells beyond the defined range. When you prevent a user from selecting locked cells in a protected Microsoft Excel worksheet, the user may now be unable to select any cells within ranges that you set up to allow users to edit. You are unable to select unprotected cells in Excel
0 kommentar(er)
