14 December 2014

How to Lock Excel Cell With Formula and Without Formula in Microsoft Excel

In Microsoft Excel definitely all make a table (either a regular table or even a table that uses functions excel). Moreover, an admin or secretarial job that every day would have used it.

When we create a table or format by including Excel formulas and functions, where the table or the format it will be using by many people of rigor and seriousness us to use Excel functions are needed. Moreover that combines the functions and formulas excel in it. You can also try out a the other way to give protection to excel sheet: Easy Ways to Give Password Protect Specific Cell in Excel Worksheet. And if you have problems with forgotten passwords excel cell, you can try to open it with a guide: How to Unlock Cell Excel Password Protectable Without Software.

To prevent all cells which contained therein Excel formulas and functions can not be changed either intentionally or not, it is better if the cells that contains the Excel functions and formulas we key in order to better maintain the security of data in it and does not cause an error of course. To see How to Lock Excel Cell With Formula and Without Formula in Microsoft Excel.

How to Lock Excel Cell With Formula and Without Formula in Microsoft Excel

How to Lock Excel Cell With Formula and Without Formula in Microsoft Excel

How to Lock Excel Cell With Formula

  1. Remove all cells locked (if this is not done, all cells will be locked) how select all sheets (ctrl + a)> right click> format cells> protection> locked tick is removed.
  2. How to Lock Excel Cell With Formula and Without Formula in Microsoft Excel 2
    How to Lock Excel Cell With Formula and Without Formula in Microsoft Excel 3
  3. How to lock the cell. Select the cells to be locked> right click> format cells> protection> make sure the tab is locked checked> ok.
  4. How to Lock Excel Cell With Formula and Without Formula in Microsoft Excel 4
  5. Enter a password. Go to the tab review> protect sheet> make sure the select locked cells unchecked> enter password> ok.
  6. How to Lock Excel Cell With Formula and Without Formula in Microsoft Excel 5
  7. Done.

How to Lock Excel Cell Without Formula

In Excel, it is common practice is to create a formula, to facilitate the work and minimize the calculation error. However, note also how to lock the cell address in a formula that does not change during the copy, which will lead to the result of the formula is not right.

It's easy, and usually these materials commonly taught at the beginning of training or study courses Microsoft Excel. And this formula from Lotus 123 era until now has not changed, which adds character dollar $ in front of the cell address. For example, cell address: D4 (column D, row 4), how to lock it, add $ in front of him. $ D $ 4, which means that the columns and rows are locked. $D4, meaning that the columns are locked. D$4, meaning rows are locked.

The following figure is an illustration of the calculation formula in Excel.

How to Lock Excel Cell With Formula and Without Formula in Microsoft Excel 6

Consider the results of Copy Paste formula in cell B13 to another cell below it. Compare formulas are locked and not locked. That is the function of the $ sign as a formula to lock the cells that serve as a benchmark in the calculation.

0 Komentar untuk "How to Lock Excel Cell With Formula and Without Formula in Microsoft Excel"