![]() ![]() DON'T FORGET TO DO THIS.ĭoing this will help you to evaluate why a formula doesn't work or it can help to understand how the formula actually does what it does, which is a great learning tool because you can go back in the formula using the same procedure to make sure that you understand correctly what is happening. Hit Ctrl + Z to return the formula to its proper form. If you don't, those values will replace the elements of the formula.not what you want.Īt this point, you can click on another element of the formula to select it and hit F9 to see what is going on in that part. To return the formula to its proper form hit Ctrl + Z. This can be values, TRUE AND FALSE, and it can also show errors. You can reverse this by going into System Preferences Keyboard and setting this item as shown in this screenshot. F9 without the key fn key pressed, Does Apple system Functions. Hit F9 and the selected part of the formula will be changed to what that selection really is. You must press this key down before it will actually do the Word Function. On a side note, Ctrl + Z will stop working once the file is saved. press Escape, before pressing Enter or stepping away from the formula cell. If you click on the bold text, that part of the formula will be selected. The Undo will work unless the file has been saved. The active part of the formula is in BOLD. You will see a dialogue box that shows the elements that the function uses. Click in the formula past the opening bracket following a function where the cell references start. The formula will appear in the Formula Bar. If you have a formula that you want to see how it is calculating, the F9 key is a great help. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |