Prevent formula bar from covering up column headers?

DougStroud

Well-known Member
Joined
Aug 16, 2005
Messages
2,966
Is there a setting to prevent the formula bar from covering up the column headers when the data in a cell is longer than the screen width and it wraps the text onto a second line? When the text wraps this prevents selecting a specific column heading.

thanks,

ds
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
You could put a Selection_Change event in your worksheet code, and test to see whether a selected cell's contents will be overly large and bloat the formula bar, and switch off the formula bar while that cell is selected.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
hello,

talking about settings
you could lock the formula from viewing and protect your sheet

kind regards,
Erik
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
Hi DS

To select to column you can use CTRL+SPACE.

Anyway when I have a big formula and I want to see the worksheet, I click on the restore button and set the top of the worksheet window below the formula bar. When I leave the cell I just press the max button.

Hope this helps
PGC
 

DougStroud

Well-known Member
Joined
Aug 16, 2005
Messages
2,966
Thanks everyone,
All nice solutions.
I liked Pgc01's the best, selecting the restore button for simplicity and quick-- which is almost what your workaround link was doing Richard, but not having to display other open worksheets.
I also liked Erick's, it took a minute to remember how to lock/protect since all my work is for my eyes only, and I don't use protection regularly... but this saves a step when working on a file consistently, not having to switch back and forth.

Glenn,
I will try your solution in a little bit. I have to head off to work-- changing gears/hats today- I am painting today, literally wearing a different hat, a painter's cap-- :)

Thanks for everyone's thoughts on the issue-- very much,


Doug
 

Forum statistics

Threads
1,140,937
Messages
5,703,256
Members
421,289
Latest member
fbohlandt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top