Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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. –  user984532 Feb 9 '12 at 15:40
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.