If you want to keep your data locked away from others, you can do so using Microsoft Excel Online. First, open Microsoft Excel Online. Then click the File tab and select Options. On the Options dialog box, click the Protection tab. Under Lock Cells, select the lock type that you want to use. For more detailed article you may check out this blog ...Aug 24, 2023 ... How to Lock Formula Cells in an Excel Worksheet · Now that your formal cells are selected, you can proceed to lock them. Right-click on them and ...Being locked into a cellphone plan is one of the worst things about owning a cellphone. If you’re unhappy with the service, you have to either put up with it or be willing to fork ...May 10, 2023 ... Click right on the cell we want to protect, and from the Format Cells option, select LOCKED from the protection tab. How to Lock and Protect ...To lock cells in Excel on Mac, you need to first unlock all the cells since Excel locks them by default. Then, you can go ahead and lock specific cells in your worksheet. Select the cells that you want to lock. On the Format menu, click Cells, or press COMMAND + 1. Click the Protection tab, and then make sure that the Locked check box is selected. 101. Try using. Worksheet.Protect "Password", UserInterfaceOnly := True. If the UserInterfaceOnly parameter is set to true, VBA code can modify protected cells. Note however that this parameter does not stick. It needs to be reapplied each time the file is opened. Share. Improve this answer. Follow.Highlight a cell or multiple cells, then right-click a selected cell and click Format Cells… . ( You can also press CTRL-1 to open the needed dialog box.) In the …5 days ago · In case you want to lock all cells in a spreadsheet, use Ctrl+A, the shortcut to highlighting all cells in an Excel worksheet Step 5. Lock the Cells with the Shortcut. With your cells selected, press Ctrl+Shift+L. This keyboard shortcut instantly locks the selected cells. Apple users, check out the shortcut to lock cells in Excel for Mac.Sep 12, 2020 ... Step 1: Select the cell with formulas that you want to lock & Press Ctrl + 1; Step 2: In the format cells dialog box, select the protection tab.Learn how to lock cells in a spreadsheet to prevent them from being altered, deleted, or reformatted. You also need to protect the sheet or workbook to make the …That's because all cells in Excel are locked by default. Click CTRL+A to select all cells. Right-click and choose Format Cells from the drop-down, or press CTRL+1. Go to the Protection tab and uncheck the Locked checkbox and click OK. Now, select specific cells you'd like to lock. For example, select cells A1 and A2.Jan 8, 2024 · Method #2 – Protect Sheet Feature in the Home or Review Tab. The steps to use the Protect Sheet feature to lock column in Excel from editing are as follows:. Select the worksheet where we need to lock columns by clicking the triangle on the top left corner of the work area. And right-click to choose Format Cells from the context menu.; The …HOW TO LOCK A FORM IN EXCEL // Learn to lock cells and protect your sheet when you create a fillable form in Excel. Unlike forms created in MS Word, there a ...3. Lock Cells in Column or Row without Protecting Sheet with Excel VBA. We can also lock cells in a column or row without protecting the sheet with Excel VBA.Here, we will lock Cell B6 and B9 expressing them with columns and rows.In this example, you will try to select Cell B6.But the VBA code will select Cell E6 in place of …How to Lock a Cell in Excel. Locking cells in Excel can be important when you want to protect certain data or formulas from being changed by other users. Here's a step-by-step guide on how to lock a cell in Excel: Step-by-step guide on how to lock a cell. Select the cell – Click on the cell that you want to lock.Jan 17, 2022 · 1. First of all, you need to select the cells that you want to lock. 2. Go to the “Home” tab of your Excel sheet and select “Format” to the far right. 3. From the drop-down menu, choose “Lock Cell”. IMPORTANT: Although your selected range is now locked, it …Freeze/Lock More than One Row in Excel. If you have more than one header rows in your dataset, you may want to freeze all of it. Here is how to freeze rows in Excel: Select the left-most cell in the row which is just below the headers row. Click the ‘View’ tab. In the Zoom category, click on the Freeze panes drop downLearn how to lock cells in Excel worksheets and workbooks to prevent accidental changes. Follow the steps to select, format, and protect the cells you want to lock or unlock.Learn how to lock cells and protect your worksheets with a password in Excel. Follow the steps to select, format, and lock specific cells or all cells in a sheet.Jun 29, 2022 · Lock a Formula Cell in Excel. To avoid getting your formula cells altered, first, launch your spreadsheet with Microsoft Excel. In your spreadsheet, select all cells by pressing Ctrl+A (Windows) or Command+A (Mac). Then right-click any one cell and choose "Format Cells." On the "Format Cells" window, from the top, select the "Protection" tab. If you want to lock a single cell then you need to. Choose the cell first on which you want to apply the lock feature. Go to the formula bar. Select the formula to highlight the lock applied on the whole formula or just part of the formula. Press F4. This is how to lock cells in excel formula works. You can also unlock them via unlocking the ...Mar 18, 2023 · Step 2 – Find and Lock Cells Containing Formulas. Step 3 – Protecting the Worksheet. How to Lock a Column in a Worksheet. Step 1 – Unlock all Cells on the Worksheet. Step 2 – Select & Lock all the Column Cells. Step 3 – Protecting the Worksheet. How to Lock an Entire Workbook. You can prevent users from accessing certain cells in a spreadsheet based on the values in specified ranges. Learn how to do this with three different exampl...Text value corresponding to the type of data in the cell. Returns "b" for blank if the cell is empty, "l" for label if the cell contains a text constant, and "v" for value if the cell contains anything else. "width" Returns an array with 2 items. The 1st item in the array is the column width of the cell, rounded off to an integer. Below are the steps to take to protect your worksheet and lock cells. Open Excel and highlight or select all cells in your worksheet. Right-click on the selected cells and click on Format cells in the pop-up sub-menu that appears, or click on Ctrl + 1 on your keyboard after you have selected your cells. Click on the Protection tab at the right ...Jun 27, 2023 · Excel is a powerful tool for managing and organizing data, but it’s essential to protect sensitive information from accidental changes or unauthorized access. One way to achieve this is by locking cells in Excel. In this guide, we will explore the step-by-step process of locking cells, along with helpful tips and techniques to ensure the security of …Jun 29, 2022 · Lock a Formula Cell in Excel. To avoid getting your formula cells altered, first, launch your spreadsheet with Microsoft Excel. In your spreadsheet, select all cells by pressing Ctrl+A (Windows) or Command+A (Mac). Then right-click any one cell and choose "Format Cells." On the "Format Cells" window, from the top, select the "Protection" tab. This tutorial demonstrates how to lock a cell in a formula in Excel and Google Sheets. Lock Cells in Formulas. When you copy a formula, cell references in the formula change depending on where you paste. In some cases, you don’t want cell references to change and want to lock them when copying the formula. In the following example, …Select the row below the last row or to the right of the last column you want frozen. On the View tab, select Freeze Panes. To freeze a block of cells starting from the top row or first column, such as the top four rows and leftmost three columns: Select a cell, for example, D5. On the View tab, select Freeze Panes. Locking up your bike when it’s not in use is more than a nice idea ― it’s a necessity if you want to keep it from getting stolen. Thieves are always on the lookout for bikes left u...Go to the find & select button under the Editing tab. Click on the Go to special option under the drop-down arrow, and select formulas in the window. Then, open the format cells dialogue box using the ribbon or by ctrl+1. Under the protection tab, select hidden & click ok. Now your formulas are hidden. Learn how to protect your data and formulas by locking certain cells in Excel using four different methods. See step-by-step instructions, screenshots, and VBA code …Here’s how you can now lock formula cells or specific cells in Excel. Click the Find & Select button in the Editing group of the Home tab. Select Go To Special. Select Formulas in the “Go To Special” window. Click OK. This highlights the formula cells in the worksheet. To ensure that these cells can’t be changed or modified, it’s time ...Mar 21, 2023 · Press Ctrl + A or click the Select All button to select the entire sheet. 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). In the Format Cells dialog, switch to the Protection tab, uncheck the Locked option, and click OK. 2. Here’s how to lock cells in Excel, whether you’re on Windows 10 or macOS, and it's easy as pie. Learn how to lock cells in Excel and keep vital information on your spreadsheets secure.Right-click on the cell range that you want to lock. Go to “ View more cell actions ” and click the “ Protect range ” option. In the “ Protected sheets and ranges ” pane that opens up on the right, click on “ Add a sheet or range .”. [Optional] Enter a description for the cell you’re locking.Open the Format Cells menu. After selecting the cells, right-click and choose "Format Cells" from the menu that appears. Alternatively, you can go to the "Home" tab, click on the "Format" dropdown, and select "Format Cells." B. Locking the Selected Cells.Introduction. When working with Excel 2016, it's essential to understand how to lock cells to prevent accidental changes to important data. By locking cells, you can protect the integrity of your spreadsheets and ensure that crucial information remains secure.In this tutorial, we will provide a step-by-step guide on how to lock cells in Excel 2016, along with an …Select View > Freeze Panes > Freeze First Column. The faint line that appears between Column A and B shows that the first column is frozen. Freeze the first two columns. Select the third column. Select View > Freeze Panes > Freeze Panes. Freeze columns and rows. Select the cell below the rows and to the right of the columns you want to keep ... Combination locks use wheel packs to set the combination inside the lock. Learn about combination locks and see pictures of the inside of a combination lock. Advertisement Most com...Dec 19, 2023 · To begin with, let’s calculate the speed of light for the Ice medium. First, select cell D9 to store the calculated value. Step-2: Then, type “ = ” first. Now, this is a crucial point: Next, type B5 and then press the F4 key. Now, type “ * ”. Then, type D8 and then press the F4 key. Finally, press the ENTER button. Where .Cells.Locked = False unlocks all cells and .Cells.SpecialCells (xlCellTypeBlanks).Locked = True locks all cells blank cells (Note: a ="" value through formulas is considered a value and will stay unlocked) Both Unprotect and Protect are needed to have full effect of your changes.Aug 23, 2021 · Learn how to lock cells in Excel to prevent editing by individual cells, larger cell ranges, or entire worksheets. Follow the steps to enable or disable cell lock protection and worksheet protection in Excel. See the difference between worksheet protection and worksheet lock. Click the Protection tab, check the box for the Locked option, then click OK. In the menu bar, click the Review tab. In the Protect group, click the Protect Sheet option. The Protect Sheet window opens. Enter a password for unlocking the protected cells in the Password to unprotect sheet text field. In the Allow all users of this worksheet to ...Below are the steps to take to protect your worksheet and lock cells. Open Excel and highlight or select all cells in your worksheet. Right-click on the selected cells and click on Format cells in the pop-up sub-menu that appears, or click on Ctrl + 1 on your keyboard after you have selected your cells. Click on the Protection tab at the right ...Here’s how you can now lock formula cells or specific cells in Excel. Click the Find & Select button in the Editing group of the Home tab. Select Go To Special. Select Formulas in the “Go To Special” window. Click OK. This highlights the formula cells in the worksheet. To ensure that these cells can’t be changed or modified, it’s time ...How to Lock Cells in Excel. 1,072,946 views. 12K. In this short video tutorial, I’ll show you how to lock cells in an Excel spreadsheet to protect them from overwriting. …Dec 8, 2023 · Below are the steps to take to protect your worksheet and lock cells. Open Excel and highlight or select all cells in your worksheet. Right-click on the selected cells and click on Format cells in the pop-up sub-menu that appears, or click on Ctrl + 1 on your keyboard after you have selected your cells. Click on the Protection tab at the right ... Locking cells in Excel 2016 is essential for protecting important data and maintaining data integrity. Cell locking provides security by preventing accidental changes to crucial information in spreadsheets. Following the step-by-step tutorial on locking cells can help users understand the process and its benefits.Introduction. When working with Excel formulas, it is essential to understand the importance of locking cells in order to avoid potential issues. By locking cells, you can prevent accidental changes to the formula and ensure the integrity of your data. Without locking cells, there is a risk of errors and inaccuracies that can impact the reliability of your …Mar 27, 2019 · In this short video tutorial, I’ll show you how to lock cells in an Excel spreadsheet to protect them from overwriting. What we want to do here is leave the ... Jun 27, 2023 · Why Locking Cells in Excel is Important. Locking cells in Excel is important for several reasons. When you are working with a large and complex spreadsheet, it is easy to make an accidental change to a cell or range of cells. This can result in serious consequences, especially when working with important data or formulas.Jan 24, 2020 · Step 4: On one of the selected cells, right-click on Windows 10 (two-finger tap on macOS). Then click on Format > Protection again. Step 5: This time, tick off “Locked” and click OK. This ... Jan 21, 2021 · To create a drop-down list: Select cell B3 to make it the active cell . Select Data . Select Data Validation to open the Data Validation dialog box. Select the Settings tab. Under Allow, select the down arrow. Choose List. Place the cursor in the Source text box. Highlight cells E3 through E10 in the worksheet to add the data in this range of ... Jun 27, 2023 ... Hi all I just wondered if there was a way to use UiPath to lock certain columns in Excel, e.g. lock A through R and leave S unlocked?Mar 18, 2023 · Step 2 – Find and Lock Cells Containing Formulas. Step 3 – Protecting the Worksheet. How to Lock a Column in a Worksheet. Step 1 – Unlock all Cells on the Worksheet. Step 2 – Select & Lock all the Column Cells. Step 3 – Protecting the Worksheet. How to Lock an Entire Workbook. Learn how to lock cells in a spreadsheet to prevent them from being altered, deleted, or reformatted. You also need to protect the sheet or workbook to make the …Dec 27, 2019 · 2. In the "Home" tab, click on the arrow under "Alignment" to open the "Format Cells" pop-up window. 3. Click on the "Protection" tab. 4. Uncheck the box next to "Locked". Most Excel documents ... Introduction. When working in Excel, it's essential to lock certain cells to prevent accidental changes or deletions. This ensures the integrity and security of your data, especially when sharing the file with others.In this tutorial, we will explore how to lock cells in Excel without having to protect the entire sheet, giving you more control over your data while …1. Unlock all cells on the sheet. By default, the Locked option is enabled for all cells on the sheet. That is why, in order to lock certain cells in Excel, you need to …Select the row below the last row or to the right of the last column you want frozen. On the View tab, select Freeze Panes. To freeze a block of cells starting from the top row or first column, such as the top four rows and leftmost three columns: Select a cell, for example, D5. On the View tab, select Freeze Panes. The cell pointer in Excel is the active cell or the selected cell and is highlighted by a bolder rectangle. The location of the cell pointer is listed below the tool bar to the lef...Learn how to lock cells in Excel worksheets to protect your data and formulas from accidental changes. Follow the step-by-step instructions to lock specific cells, …Click the Format button on the Home tab. Select Format Cells . Click the Protection tab. Clear the Locked check box. You can also toggle the lock on and off by clicking the Format button and selecting Lock Cell . Locking and unlocking cells only takes effect once the sheet is protected. Click OK . Unfreeze/Unlock Columns and Rows in Excel. Notes. Steps to Lock Rows/Columns in Excel. Go to the View tab and click the Freeze Panes button. From the drop down menu select if you want the header row, the first row of data, or the header column, the first column of data to be frozen. I will select Freeze Top Row to lock the first row in place ... Nov 10, 2023 ... How To Lock Cells In Excel? ... Step 1 - Select the cells you want to lock. You can do this by clicking and dragging over the cells or using ...When you want security you can trust, Master Lock delivers. Since 1921, this company has been manufacturing padlocks and other security devices designed to give you peace of mind. ...Start by selecting the cell where you want the result to appear. Enter the formula using the INDIRECT function and a cell reference that contains the address of the cell you want to lock. Test the formula by changing the contents of the referenced cell to see if the locked reference updates accordingly.Worksheet level protection is not intended as a security feature. It simply prevents users from modifying locked cells within the worksheet. Following are the different options available for protecting your Excel data: File-level: This refers to the ability to lock down your Excel file by specifying a password so that users can’t open or ... Display the worksheet with the cells you want to lock or protect. Press Ctrl + A to select all (you may need to press Ctrl + A twice). Right-click any of the selected cell (s) and choose Format Cells or press Ctrl + 1. The Format Cells dialog box …Jan 12, 2023 · 2. Right-click on your selection, select Format Cells, and click on the Protection tab. (Alternatively, under the Home tab, click on the expansion icon next to Alignment, and in the Format Cells ... Here’s how you can now lock formula cells or specific cells in Excel. Click the Find & Select button in the Editing group of the Home tab. Select Go To Special. Select Formulas in the “Go To Special” window. Click OK. This highlights the formula cells in the worksheet. To ensure that these cells can’t be changed or modified, it’s time ...Drag or copy formula and lock the cell value with the F4 key. For locking the cell reference of a single formula cell, the F4 key can help you easily. Select ...101. Try using. Worksheet.Protect "Password", UserInterfaceOnly := True. If the UserInterfaceOnly parameter is set to true, VBA code can modify protected cells. Note however that this parameter does not stick. It needs to be reapplied each time the file is opened. Share. Improve this answer. Follow.Mar 21, 2023 · Press Ctrl + A or click the Select All button to select the entire sheet. 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). In the Format Cells dialog, switch to the Protection tab, uncheck the Locked option, and click OK. 2. The cell pointer in Excel is the active cell or the selected cell and is highlighted by a bolder rectangle. The location of the cell pointer is listed below the tool bar to the lef...Open the Format Cells menu. After selecting the cells, right-click and choose "Format Cells" from the menu that appears. Alternatively, you can go to the "Home" tab, click on the "Format" dropdown, and select "Format Cells." B. Locking the Selected Cells.When you want security you can trust, Master Lock delivers. Since 1921, this company has been manufacturing padlocks and other security devices designed to give you peace of mind. ...What Is Lock Cells In Excel? The Lock Cells in Excel function enables users to lock information within a cell (s). It protects the data from getting forged, edited, or deleted …This is how to protect formulas in Excel by locking the cells. In this method, even though the cells will be locked you can still see the formula used. To hide the formula from others, follow the second method. Hiding the Formula Bar. An easy way to prevent a user from making an undesired change in a cell, you can hide the formula in the ...Aug 13, 2022 · When you disable Scroll Lock and press the arrow keys, Excel lets you move between cells in your spreadsheet. For example, if you press the Down Arrow key, you go down a cell in your worksheet. This is usually the default behavior and allows for quick editing. If you enable Scroll Lock, on the other hand, Excel lets you scroll your …5 days ago · In case you want to lock all cells in a spreadsheet, use Ctrl+A, the shortcut to highlighting all cells in an Excel worksheet Step 5. Lock the Cells with the Shortcut. With your cells selected, press Ctrl+Shift+L. This keyboard shortcut instantly locks the selected cells. Apple users, check out the shortcut to lock cells in Excel for Mac.To lock specific cells in Excel, follow these steps: Select the cells – Start by selecting the cells that you want to lock. This can be done by simply clicking and dragging the cursor over the desired cells. Open the Format Cells dialog – Right-click on the selected cells and choose "Format Cells" from the context menu.No, to lock cells in Excel, you need to protect your worksheet with a password. The password is essential, as it ensures that only authorized users can edit the protected cells or worksheet. Make sure to keep your password in a safe place to avoid any inconveniences in the future. 2.Microsoft Excel is one of the most popular and easy-to-use software. It was created by Microsoft and it allows users to organize and format data in rows and columns format. In this article, we will see how we can lock cells in Excel and protect them with a password. How to Lock Cells in Excel. Here are the steps you can follow to lock cells in ...Apr 1, 2021 · With the cells selected, either right-click and choose Format Cells or click Format > Format Cells in the ribbon on the Home tab. Pick the Protection tab and check the box for Locked. Click OK. Go ...
Select View > Freeze Panes > Freeze First Column. The faint line that appears between Column A and B shows that the first column is frozen. Freeze the first two columns. Select the third column. Select View > Freeze Panes > Freeze Panes. Freeze columns and rows. Select the cell below the rows and to the right of the columns you want to keep ... . Hertz rental caar
Select the whole worksheet, i.e. click on the little square box above the row header 1, and to the left of the column header A. Click Format/Format Cells/Protection, and tick the "Locked" checkbox, i.e. to lock every cell on the worksheet. Select the range you don't need to protect. Click Format/Format Cells/Protection/Locked and untick the ...To lock or unlock the entire excel worksheet, the steps are listed as follows: a. Select the entire worksheet by pressing “Ctrl+A.”. b. Right-click the selection and choose “format cells” from the context menu. c. Select the “locked” option to lock all cells. Pressing Ctrl+A or clicking the Select All button (in the left corner between Column A and Row 1). Right-clicking and choosing Format Cells… from the context menu. Going to the Protection tab and unchecking the Locked checkbox. Next, select the cell, cells, or range you want to protect and lock them. Jun 27, 2023 · Excel is a powerful tool for managing and organizing data, but it’s essential to protect sensitive information from accidental changes or unauthorized access. One way to achieve this is by locking cells in Excel. In this guide, we will explore the step-by-step process of locking cells, along with helpful tips and techniques to ensure the security of …Feb 8, 2023 ... Yes, it is possible to lock cells in Microsoft Excel without protecting the worksheet. To lock cells in Excel, you need to select the cells ...Jun 24, 2022 ... Lock the spreadsheet by using the "Ctrl+1" command to open the "Format Cells" dialog box, then go to the "Protection" tab and check &...Nov 14, 2019 · Unlock or lock the desired cells in the worksheet. Click on the Home tab. Click Format on the ribbon to open the dropdown list. Click Protect Sheet at the bottom of the list to open the protect sheet dialog box . Check or uncheck the desired options. Click OK to close the dialog box and protect the worksheet. Here are some quick steps to lock cells in Excel using this formula: =C5*D5*E2. Say you want to lock cell E2 to remain constant as you copy the formula to adjacent cells. Click E2 in the formula to place the cursor between E and 2. Press F4 on your keyboard. This will insert the dollar ($) symbols in the formula.Jun 27, 2023 · Why Locking Cells in Excel is Important. Locking cells in Excel is important for several reasons. When you are working with a large and complex spreadsheet, it is easy to make an accidental change to a cell or range of cells. This can result in serious consequences, especially when working with important data or formulas.Where .Cells.Locked = False unlocks all cells and .Cells.SpecialCells (xlCellTypeBlanks).Locked = True locks all cells blank cells (Note: a ="" value through formulas is considered a value and will stay unlocked) Both Unprotect and Protect are needed to have full effect of your changes.A cell in Microsoft Excel is a rectangular-shaped box on a worksheet. Any combination of numbers or words can be entered in the cell; however, Excel is generally used as a calculat...101. Try using. Worksheet.Protect "Password", UserInterfaceOnly := True. If the UserInterfaceOnly parameter is set to true, VBA code can modify protected cells. Note however that this parameter does not stick. It needs to be reapplied each time the file is opened. Share. Improve this answer. Follow.Dec 19, 2023 · To begin with, let’s calculate the speed of light for the Ice medium. First, select cell D9 to store the calculated value. Step-2: Then, type “ = ” first. Now, this is a crucial point: Next, type B5 and then press the F4 key. Now, type “ * ”. Then, type D8 and then press the F4 key. Finally, press the ENTER button. Apr 1, 2021 · With the cells selected, either right-click and choose Format Cells or click Format > Format Cells in the ribbon on the Home tab. Pick the Protection tab and check the box for Locked. Click OK. Go ... Select the whole worksheet, i.e. click on the little square box above the row header 1, and to the left of the column header A. Click Format/Format Cells/Protection, and tick the "Locked" checkbox, i.e. to lock every cell on the worksheet. Select the range you don't need to protect. Click Format/Format Cells/Protection/Locked and untick the ...Jun 27, 2023 · Excel is a powerful tool for managing and organizing data, but it’s essential to protect sensitive information from accidental changes or unauthorized access. One way to achieve this is by locking cells in Excel. In this guide, we will explore the step-by-step process of locking cells, along with helpful tips and techniques to ensure the security of …Making locked cells is an easygoing approach in Excel. We will do it using Format Cells and Protect Sheet in Excel. So, follow these steps and try them yourself. 📌 Steps: Select the range B4:D15. Press Ctrl+1 to open up the Format Cells tab. Uncheck Locked and Hidden and click OK. Now, click Review > Protect Sheet.Aug 23, 2021 · Learn how to lock cells in Excel to prevent editing by individual cells, larger cell ranges, or entire worksheets. Follow the steps to enable or disable cell lock protection and worksheet protection in Excel. See the difference between worksheet protection and worksheet lock. To lock specific cells in Excel, follow these steps: Select the cells – Start by selecting the cells that you want to lock. This can be done by simply clicking and dragging the cursor over the desired cells. Open the Format Cells dialog – Right-click on the selected cells and choose "Format Cells" from the context menu.Here’s how to unlock one cell in Excel: Open your Excel file or workbook and navigate to the sheet containing the cell you want to unlock. Select the cell you want to unlock. Right-click the cell, and in the context menu, select Format Cells. In the Format Cells dialog box, click on the Protection tab. Untick the checkbox beside “Locked”..