Look Who it Was Random video

Excel - Master Excel Formulas: 3 Ways to Enter Them - Mouse vs Arrow Keys - Episode 1211.108

2,896 views · Published 17 July 2010 · 2:49 · Indexed 1 October 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial - Master Excel Formulas: 3 Ways to Enter Them - Mouse vs Arrow Keys.

Welcome back to the MrExcel netcast! In this chapter, we're diving into the world of formulas and discussing the three different ways to enter them. As I travel around the country doing seminars, I've noticed that about 10% of people simply type out their formulas, while the majority use the mouse or arrow keys. Which method do you prefer?

For those who use the mouse, here's a cool tip for you. By customizing your Quick Access toolbar, you can add the plus, minus, multiply, and divide icons for easy access. This eliminates the need to constantly switch back and forth between the keyboard and mouse, making formula entry even faster. And who doesn't want to be a pro at entering formulas?

But for those who have been around since the days of Lotus 1-2-3, using the arrow keys may be the preferred method. And I have to say, if there was an Excel Olympics, I would want people on my team who use the arrow key method. It's the fastest way to enter formulas and can save you a lot of time in the long run.

So, whether you're a mouse person or an arrow key person, it's important to know all the different ways to enter formulas in Excel. And with these tips, you'll be well on your way to becoming an Excel formula pro. Thanks for tuning in to this episode of the MrExcel netcast. Don't forget to check out our sponsor, MrExcel.com, and stay tuned for more Excel in Depth tutorials. See you next time!

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) 3 Way to Enter Formulas
(00:18) First Way: Typing the Formula
(00:32) Second Way: Using the Mouse
(01:00) Third Way: Using the Arrow Keys
(01:20) Tip for Mouse Users: Customizing the Quick Access Toolbar
(02:30) Clicking Like really helps the algorithm

This video answers these common search terms:
Adding divide symbol to Quick Access toolbar
Customizing Quick Access toolbar in Excel
Excel 2010 in Depth
Excel productivity tips
Excel shortcuts
Formulas 3 Ways
Gross Profit %
How to enter formulas in Excel
Navigating in Excel using arrow keys
Using the keyboard to enter formulas
Using the mouse to enter formulas

This video from Chapter 8 discusses the three ways of entering formulas in Excel.

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

More from this channel