Also check that you have not pressed the Caps Lock key, which will capitalize all the text. If the second password does not match, your original one might have included a typo. Re-enter exactly the same password in that window’s text box, and press the OK button. When you press the OK button on the Protect Sheet window, a Confirm Password dialog box opens.You can select further options there so that spreadsheet users can still apply formatting changes or add hyperlinks to the formula cells. The Select locked cells and Select unlocked cells options are selected by default so that Excel users can only select, but not edit, the function cells. Enter a password for the sheet in the Protect Sheet window’s text box.Next, press the Protect Sheet button on that tab to open a password window.Nothing locks until you have applied for spreadsheet protection. Now, press the Ctrl + 1 keyboard shortcut to open the Format Cells window again, select the Locked option on the Protection tab and then click OK to close the Format Cells window.Or hold the left mouse button and drag the cursor over multiple cells. To select multiple cells, press and hold the Ctrl key. Alternatively, you can manually select a function cell with the cursor.
Click the Formula s radio button to select all the formula type options, and press the OK button.Now, select Go To Special… from the dropdown menu, as shown below.
0 kommentar(er)
