Look Who it Was Random video

Excel - Working with Long Formulas in Excel that Expand beyond the Formula Bar - Episode 411

318 views · Published 29 September 2009 · 2:02 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Working with Long Formulas in Excel that Expand beyond the Formula Bar.

Welcome back to the MrExcel netcast, where we discuss all things Excel. Today, we're diving into one of the new features in Excel 2007 - the expanded FormulaBar. As many of you may know, working with long formulas in Excel 2003 could be quite frustrating. When selecting a formula in a cell, the FormulaBar would automatically extend and cover the cell, making it impossible to see both the formula and the cell value at the same time. But fear not, because Excel 2007 has completely fixed this issue.

Let's take a look at how the expanded FormulaBar works. In Excel 2007, when selecting a long formula in a cell, the FormulaBar will only show one line at a time. However, by clicking on the "Expand Formula Bar" button or using the shortcut Ctrl+Shift+U, the FormulaBar will expand and move the grid down, allowing you to see both the formula and the cell value simultaneously. This simple fix eliminates the frustration of not being able to see the entire formula and makes working with long formulas a breeze.

This issue has been plaguing Excel users since the ‘97 version, but with the expanded FormulaBar in Excel 2007, it's a thing of the past. No more constantly scrolling up and down to see the formula and the cell value. This feature may seem small, but it's definitely a game-changer for those who work with long formulas on a regular basis. So if you're still using Excel 2003, it may be time to upgrade and take advantage of this and many other new features in Excel 2007.

Thanks for tuning in to today's netcast from MrExcel. Don't forget to hit the like button and subscribe for more Excel tips and tricks. See you tomorrow for another episode!

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) Introduction to Excel 2007 features
(00:23) Annoying issue with long formulas in Excel 2003
(00:52) Solution in Excel 2007
(01:03) Scrolling and expanding formula bar in Excel 2007
(01:19) Grid moves down to show both formula and value
(01:31) Simple fix for a long-standing annoyance in Excel
(01:42) 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:
Annoying formula display in Excel 2003
Cell value and formula display in Excel 2007
Excel 2007 features
Excel 2007 formula display fix
Excel annoyances
Excel formula display issue
Excel netcast from MrExcel
Excel tips and tricks
Expanding formula bar in Excel 2007
Formula bar in Excel 2007
Grid movement in Excel 2007 formula bar
Long formulas in Excel 2007

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



Do you notice that in Excel 97-2003, if you have a really long formula in row 1, when you select a cell, the formula bar obscures the value in the cell? This is now fixed in Excel 2007. Episode 411 shows you how.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

More from this channel