When you no longer need to keep formulas in cells but wish to retain the results of the formulas, use a right-dragging technique to convert the formulas to values, instead of using a multi-step command sequence. You can either copy the results into other cells or into the cell that contain the formulas.
- [Voiceover] We're looking at a worksheet called…Convert Formulas to Values.…There are times in Excel where you've got some formulas,…and, in effect, you're saying:…I no longer want to keep the formulas,…but I wanna keep the results.…Sometimes it's a situation where you've got many,…many formulas and you'll save some worksheet storage space…and also some recalculation space by…getting rid of the formulas, keeping the results.…At other times, you just no longer want the formulas,…you simply want the results to be displayed.…Now, Column A here isn't that bad,…but I'd like to have that data there so…that only the first letters of each name are capitalized.…
So, I'll be right-clicking Column B to insert a new…column here, and I'll use a function called Proper.…Proper takes a value, or a reference here in Cell A-two,…and will only capitalize the first letters.…So I'll press Control+Return here,…and we'll see what's happened.…I'll double-click to copy this down the column.…So, Column B is filled with formulas using the function…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome46s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
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: Convert formulas to values with a simple drag