Look Who it Was Random video

Excel - Equation Editor in Excel - Episode 1245

2,169 views · Published 14 July 2010 · 3:14 · Indexed 29 September 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: How to Use the Equation Editor in Excel

Welcome to another episode of the MrExcel netcast. In this episode, we will be diving into chapter 28 of our Excel In Depth series, where we will be exploring the powerful Equation Editor feature in Excel 2010.

The Equation Editor can be found on the Insert tab, in the Symbols group. However, I have added it to my Quick Access Toolbar for easy access. When you open the Equation Editor, you will see a variety of pre-built equations, but the real magic happens when you choose "Insert New Equation" at the bottom of the list.

But before we can insert a new equation, we need to have a drawing object on our sheet. So let's go to the Insert tab and choose Shapes. I'll draw a simple shape and then change it so it's not filled in. Now, we can go back to the Equation Editor and choose "Insert New Equation" at the bottom. This will bring up a gallery of symbols and structures that we can use to build our equation.

One thing to note is that when you choose a structure, such as a fraction or integral, you will see three boxes highlighted. You will need to click inside these boxes in order to type your equation. And don't worry if you're not a math whiz, the Equation Editor has a variety of symbols and structures to choose from, making it easy to create complex equations.

I've also noticed that when working with fractions, it can be helpful to build the equation as a Linear equation first, then change it to a Professional equation. This will ensure that the fractions are displayed correctly. Overall, the Equation Editor is a powerful tool for displaying equations in Excel, and it's a feature that was originally added to Word 2007 and later added to Excel 2010.

I hope you found this episode helpful and that it will make the scientists, engineers, and mathematicians out there happy to have this powerful tool at their disposal. Thank you for tuning in to the MrExcel netcast, and be sure to join us next time for more Excel tips and tricks!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) The Equation Editor 
(00:16) Location of Equation Editor 
(00:27) Inserting a New Equation 
(00:37) Requirements for Inserting a New Equation 
(00:48) Creating a Drawing Object 
(01:03) Using the Equation Tools 
(01:19) Different Symbol Options 
(01:29) Structures and Mathematical Symbols 
(01:42) Inserting Symbols and Typing in Boxes 
(01:55) Building Fractions 
(02:05) Purpose of Equation Editor 
(02:15) Tips for Using Fractions 
(02:41) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Basic Math symbols in Equation Editor
Drawing tools in Equation Editor
Equation Editor in Word 2007 and Excel 2010
Equation tools in Excel
Excel 2010 Equation Editor
Fractionals in Equation Editor
Greek letters in Equation Editor
Insert New Equation in Excel
Linear equation vs Professional equation in Equation Editor
Showing equations in Excel
Structures in Equation Editor
Symbols in Excel Equation Editor


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152852/

Microsoft took the vastly improved Equation Editor from Word 2007 and added it to Excel 2010.

More from this channel