How to hide and lock formulas in Excel


Download 91.59 Kb.
bet3/5
Sana23.12.2022
Hajmi91.59 Kb.
#1044248
1   2   3   4   5
Bog'liq
How to hide and lock formulas in Excel

Protect Sheet.


  • The Protect Sheet dialog window will appear, and you type a password in the corresponding field.

    This password is needed for unprotecting the worksheet. No one, even yourself, will be able to edit the sheet without entering the password, so be sure to remember it!

    Also, you need to select the actions that are allowed in your worksheet. As you see in the screenshot above, two checkboxes are selected by default: Select locked cells and Select unlocked cells. If you click the OK button leaving only these two options selected, the users, including yourself, will be able only to select cells (both locked and unlocked) in your worksheet.
    If you want to allow some other actions, e.g. sort, auto-filter, format cells, delete or insert rows and columns, check the corresponding options in the list.

    • Once you've selected any additional actions you want to allow, if any, click the OK button.

    • The Confirm Password dialog box will appear and ask you to retype the password, to prevent an accidental misprint from locking up your Excel worksheet forever. Retype the password and click OK.

    Done! Your Excel formulas are now locked and protected, though visible in the formula bar. If you also want to hide formulas in your Excel sheet, read through the following section.
    Tip. If you need to edit or update your formulas once in a while and you don't want to waste your time on protecting / unprotecting the worksheet, you can move your formulas to a separate worksheet (or even workbook), hide that sheet, and then, in your main sheet, simply refer to the appropriate cells with formulas on that hidden sheet.
    How to hide formulas in Excel
    Hiding a formula in Excel means preventing the formula from being shown in the formula bar when you click a cell with the formula's result. To hide Excel formulas, perform the following steps.

    1. Select a cell or range of cells containing the formulas you want to hide.

    You can select 
    Download 91.59 Kb.

    Do'stlaringiz bilan baham:
  • 1   2   3   4   5




    Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
    ma'muriyatiga murojaat qiling