Excel Rev Up - Formula Bar Tricks: Podcast #1293

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Nov 24, 2010.
Today in Episode #1293, Bill takes a look at the Formula Bar in Excel 2010: "...you will never have a long formula spilling over the formula bar and covering your worksheet cells."...

"Rev Up to Excel 2010: Upgraders Guide to Excel 2010"
maxresdefault.jpg


Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Wrap up to excel 2010 Chapter 9: Formula Bar Tricks.
Well hey all right, welcome back to the MrExcel netcast.
I'm Bill Jelen. Working through the Rev Up To Excel 2010 book.
This is the book all about for people upgrading from Excel 2003 straight to 2010.
One of those things that used to be very maddening in Excel 2003 and earlier was the Formula Bar.
The formula bar, if the formula is too long for the formula bar, the formula would spill out over the formula bar and sometimes cover up a cell in your spreadsheet.
You know it only happened in the first couple of rows and you know and you couldn't see both the cell in the formula at the same time, very annoying thing we'll check this out.
I have a really long formula here, in cell Q2 and a couple of things happen.
First of all, the formula bar gets this up and down icon showing that it's not showing us all the things, so I could scroll through the formula one line at a time, not really what I want to do or I can hit this icon to open the Formula Bar.
Formula Bar stretches to be as long as it needs to be, but Microsoft moves the spreadsheet down. That way I can continue to see the formula and the results, also the other cells around themselves that we can see, if any of our being referred to, make the Formula Bar go back, just click the up arrow and it goes back, so it's one of those things that was irritating when it happened, it didn't happen a lot but Microsoft took care of it for us, here and we have the amazing expanding Formula Bar in Excel 2010.
Hey, all right, I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
 

Forum statistics

Threads
1,213,546
Messages
6,114,253
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top