disable formula toolbar dropdown

G

Guest

I want to disable the text dropdown functionality of the formula toolbar. It
is really annoying when you select a cell with more than a 100 characters and
the formula bar drops down to display the entire contents of that cell,
essentially blocking the the first few rows from view, and this also prevents
you from manipulating column sizes.

I only want the formula bar to show me as much of the cells content as it
can in that one line. Does any one know how to change this setting.

Thank You
 
G

Guest

An annoying probwhich has bothered most of us.

a work around is Windows>arrange>Horizontal, and move the top of the sheet
down so that the cell can be seen entirely under the formula toolbar.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top