Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Adding a Little Animation to Your Life
Converting a Range of URLs to Hyperlinks
Making the Formula Bar Persistent
When you select a cell in a worksheet, the contents of that cell are shown in the Formula bar. If the contents are longer than what can be displayed in a single line on the Formula bar, the depth of the Formula bar increases so that the entire formula can be displayed. When you move to another cell, the Formula bar again decreases in depth to a single line.
The problem with an automatically adjusting Formula bar is that it can obscure other elements on the screen. If the Formula bar takes up two or three lines of depth, it overlays the column headers and other cells in the worksheet. This can be distracting, at times.
Unfortunately, there is no way to instruct Excel to a) limit the Formula bar to a set depth, or b) decreasing the size of the type in the Formula bar so more can fit within a single line. (At least this is true for versions of Excel prior to Excel 2007—more on that in a moment.) The best you can do is to simply remove the Formula bar completely, so it is not visible. (If you have no Formula bar displayed, then it cannot expand and obscure information in the worksheet.) You can turn off the Formula bar in this manner if you are using a version of Excel prior to Excel 2007:
Excel 2007 gives you more flexibility. It allows you to modify the number of lines used by the Formula bar. That way it will always take a specific amount of space and you won't be bothered by it jumping around as much. To expand the Formula bar (so you can see everything it contains), click the tool at the very right edge of the Formula bar. When you hover the mouse pointer over the tool, the ToolTip says "Expand Formula Bar."
If you want to turn off the Formula bar completely in Excel 2007, follow these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2730) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.