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

Office Tips

Read more

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

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 the cell. Select the cells to be locked> right click> format cells> protection> make sure the tab is locked checked> ok.

3. Enter a password. Go to the tab review> protect sheet> make sure the select locked cells unchecked> enter password> ok.

4. 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.

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.

By: admin

Easy Ways to Give Password Protect Specific Cell in Excel Worksheet

Easy Ways to Give Password Protect Specific Cell in Excel Worksheet

Office Tips

Read more

One of the advantages of the Microsoft Excel application is the function Protect Sheet. This function can be used to lock the cell in a sheet, which is the goal so that the cell can not be edited. For this occasion I will give you tips and tricks to give the password to protect certain cells or only partially, and some other cells that can still be edited.

With the protection on the file, will maintain the confidentiality of our data in it. by relying on the protection of our files can also be a boomerang for the creator. why? you know how? could have been the creator of the forgotten password of password that has been made. Severe anyway? hopefully not happen to you. But do not worry if it happens, you can open it with a trick that I gave earlier, How to Unlock Cell Excel Password Protectable Without Software.

Easy Ways to Give Password Protect Specific Cell in Excel Worksheet

1. First block cell which want to be able to edit. Eg in the example image below my block on the cell or range E5, E7, E9, E11 and E13. Then click Format and click once on the Lock Cell to change the selected cell becomes Unlock Cell.

2. Then click Format once again but this time choose Protect Sheet

3. In the Protect Sheet window, click unchek the option Select locked cells, Do not forget to add a password, then click OK. Confirm Password window will appear, enter the same password again and finally click OK.
4. Done. If all steps are correct then it should only last cell in unclock alone that can be selected (clicked) and edited, while another cell can not clicked as locked or protected.

By: admin

How to Unlock Cell Excel Password Protectable Without Software

How to Unlock Cell Excel Password Protectable Without Software

Office Tips

Read more

For the safety of the data that have been made, usually performed by the user is to provide a password in the file that it creates. Thus, not everyone can open the file and used as good as his own. The data is usually in the form of protectable important data that should not be changed by people who are not interested in it. In the data created in MS Excel can also be protectable or secured with a password or a password to be able to edit or change it. Usually that is often given passwords are cells that are specific formula that should not be changed arbitrarily. When you change the data in the cell that protectable, will appear in order to enter the password window

The password when freshly made, will be safe alias will still remembered in the head. However, if the file has not opened because there are new files, then it could be a password or a password that first made into oblivion. Consequently you yourself can not edit the file that you created yourself. To overcome this problem, you can use the following ways.

How to Unlock Cell Excel Password Potectable Without Software

1. Open the excel file that cell given protected.
2. Press Alt + F11, it will display a window in Microsoft Visual Basic For Application.
3. Click Insert and then select Modules

4. Copy the code below and paste it in the window that appears module.

Sub PasswordBreaker() 'Author unknown but submitted by brettdj of www.experts-exchange.com Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _ Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) If ActiveSheet.ProtectContents = False Then MsgBox "One usable password is " & Chr(i) & Chr(j) & _ Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _ Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) ActiveWorkbook.Sheets(1).Select Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _ Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _ Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) Exit Sub End If Next: Next:Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub

5. Then click save

6. Still in the Microsoft Visual Basic window, click the Tools menu, then select Macros

7. After that comes the macros window and click Run

8. Appears popup and click OK
9. Congratulations ... .. A locked cell can already be reopened

By: admin

How to Change Animation Direction in Microsoft PowerPoint 2013

How to Change Animation Direction in Microsoft PowerPoint 2013

Office

Read more

How to Change Animation Direction in Microsoft PowerPoint 2013 - The addition of animation in PowerPoint documents, is an added value that makes the process of becoming a more attractive presentation. Moreover, with the animation process will be drawn easily from every step that you convey to the public.

There are different kinds of animations that can be found in the PowerPoint program, sometimes even partially immersed users in selecting an animation rather than working on the main material. Animation Direction typically been provided, but not rare at him not to our liking. The solution, change the direction of the animation itself so that you become more lively presentation.

How to Change Animation Direction in Microsoft PowerPoint 2013

1. Click the slide you want to modify, then click the Animations tab menu - Effect Options and then select one of five options given direction.

2. An alternative way you can do from the same menu but is clicked a small needle in the lower left corner of the menu Effect Options and click "Additional Effect Options".

3. Now in this window you can set the direction, speed and duration of the animation.

That way, you can now set the animation scheme, according to the prepared presentation groove, good luck. A few tips from us on how to change the direction of the animation in Microsoft PowerPoint 2013.

Read previous topic : How To Apply One Background To All Slides at Once in MS PowerPoint

By: admin

How To Apply One Background To All Slides at Once in MS PowerPoint

How To Apply One Background To All Slides at Once in MS PowerPoint

Office

Read more

How To Apply One Background To All Slides at Once in MS PowerPoint - Background is an important element of a presentation, where the background can not be separated from the slide as well as animation and the document itself. But one by editing the background presentation takes a minute instead.

To overcome this problem, there are tips on how to apply one background to all slides at once in MS PowerPoint without having to edit them one by one. Same modification a lot of quality, color and texture are all the same, but the difference all you do with one modification without having to start over for each slide.

How To Apply One Background To All Slides at Once in MS PowerPoint

1. Open Microsoft PowerPoint and create a new document or open an existing document. In any slides right click and then click Format Background.

2. In the Format Background window, click the Fill and fill one of the options provided.

3. Once you select the Fill option, now click the Apply to All button and close the Format Background window to see the results of the modifications we just did.

What happened? It should present the background of all slides of your PowerPoint document into one color or one style of suit that you choose in the previous step.

It's easy, and with this step you work much faster.

By: admin