Do you find that trying to either write or fix formulas in Microsoft Excel can be a pain? Do you wish that you could expand the size of the formula bar to see more of the formula that you are working on?I remember back in the day when Microsoft Excel 2003 and prior versions didn’t have this feature. Then we upgraded to Microsoft Office 2007 and voila! I was just playing around with the software and stumbled upon this great feature.
All you need to do is drag the bottom of the formula bar as far as you need it to go and release your mouse button! That’s it!
Now you have a larger area to work with.
Subscribe to The Professional Assistant feeds or get posts e-mailed directly to you today.
Until next time,
Take care - of your clutter!
Post from: Administrative Assistant Tips
5 comments:
Nice blog.
Work From Home India
i knew that's great while using this , i am also a office assistant and i use most of all features of ms word.
I remember when Excel 2003 did this automatically by expanding the formula bar when you selected a celle containing a long text (either formula or plain text value)
thus overlapping the sheet itself, yes... but it was only temporary
Now due to the great enhancements of the Crosoft programmers, you (poor user) CAN do it as you want, but you HAVETO do it because it's no more done automatically...
A real pain in the @ss when you have to browse over several cells with different content: either you see nothing, or you use half of your screen just to reserve enauch space for a big formula...
Who can say it's a progress???
It's no progress that. It's a huge pain instead and also a big risk you or someone else reading your Excel sheets will miss a chunk of important info because there is no indication that more than one line of data might be residing in a cell.
Awful awful "improvement".
Microsoft have yet again fixed what wasn't broken!!
Post a Comment