The F9 key in Excel provides multiple uses, including formula evaluation, recalculation, and iteration. In this video, learn how to use the F9 key to evaluate formulas, recalculate random entries, and control iterations.
- [Instructor] The function key F9 … has multiple uses in Excel, it's frequently used … as a recalculation button, but you can also use it … for editing purposes. … In this worksheet I've got a formula in cell C6, … it's not giving me the answer that I think it should be, … so I want to pick it apart by editing the formula. … You can edit in the formula bar, or in the cell itself. … I'll double click in the cell, … and I think this portion of the formula is the problem. … But I want to know what this is equal to. … I highlight this, press the function key F9, … that's what it evaluates to. … If that's not the problem, what I really want to do now … is return the formula and highlight … a different portion of it. … So I'll press the function key Ctrl + Z, meaning undo. … And maybe it's this portion over here. … I'm going to highlight this. … Now if I highlight a portion of it … that Excel can't evaluate and press F9, … Excel tells me there's a problem with the formula. … The problem actually is with what I highlighted. …
Author
Dennis Taylor
Updated
2/23/2021Released
1/16/2015Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Intermediate
Duration
Views
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
-
Excel Tips - New This Week
-
Previous Episodes
-
Quick formatting tips8m 9s
-
Create an organization chart8m 56s
-
Auditing9m 1s
-
Adding comments and shapes7m 35s
-
Creating an Excel template7m 57s
-
Adjust banded-row formatting14m 35s
-
Dealing with circular errors8m 20s
-
Sorting tips and shortcuts8m 40s
-
Freeze Panes and Split5m 30s
-
Calculate % of change5m 41s
-
How to adjust names5m 45s
-
Sorting by moving columns4m 16s
-
Using the Solver Add-in4m 29s
-
Create picture links5m 37s
-
Display large values5m 16s
-
Create a powerful macro4m 40s
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration