Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Excel 2003, there was an UI element below menu, which showed full content of a cell where cursor was.

If a field contained a long string which would not fit into the column and would not overflow to field on the right, it would be possible to move by keyboard the cursor to that field and the top "view-whole-cell" bar would show the full string.

Where in Excel 2007+ ribbon options can I bring this or did Microsoft remove it?

share|improve this question
up vote 3 down vote accepted

It's still there:

  • Click the double down arrow on the right of the formula bar (just below the ribbon).
  • Drag the horizontal splitter to make it as large as you want.

enter image description here

If you're not seeing the formula bar at all, you can enable it here:

  • Ribbon button
  • Excel Options
  • Advanced
  • Enable "Show formula Bar" in the Display section.
share|improve this answer
    
exactly what I needed. thanks. – userJT Feb 9 '12 at 15:40

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .