
We often type “Ctrl + `” when using shortcuts.
We must always study the formula and return to formula values but never lose formulas.Since “Ctrl + `” is a toggle option, we can show formulas and values after every alternative click.Step 5: Type the password and protect the sheet.Step 4: Now, click on the “Review” tab and select “Protect Sheet.”.
Step 3: Select the “Protection” tab and check the “Hidden” box. The formatting of the cell depends upon the nature of the data present. Step 2: Right-click and select “ Format Cells Format Cells Formatting cells is an important technique to master because it makes any data presentable, crisp, and in the user's preferred format.