Step 2: Click the cell(s) that contains the data you DO NOT want to lock. Step 1: Begin by opening your Excel 2010 workbook that contains the cell you want to lock. That is why Excel 2010’s inclusion of the single-cell locking feature is so helpful. However, in many cases, that sort of total change can be counterproductive if changes still need to be made. Many people select the option of locking their entire workbook or worksheet, which is a much more thorough way of locking down the data in your Excel file. Excel provides you with the option of locking each cell individually, which leaves the rest of the worksheet open for potential edits by yourself or anyone else with editing permissions for your workbook. If you have finalized such a complex worksheet and want to ensure that particularly important data is not altered, then you need to learn how to lock a cell in Excel 2010. Very involved worksheets can include a combination of formulas and information that is very complex, and even slight changes to certain cells could lead to disastrous occurrences for the rest of the data on the sheet.
Some Microsoft Excel 2010 spreadsheets can be more complicated than others. Our article continues below with additional information and pictures of these steps. Type a password into the field, then click OK.
Remove the check mark next to Locked, then click OK.Right-click on a selected cell and choose the Format Cells option.Select the cells that you DON’T want to lock.Use these steps to lock a cell in Excel 2010. Sometimes the data that you type into a spreadsheet is something important that shouldn’t be changed by anyone.
0 kommentar(er)
