Prevent formula bar from covering up column headers?

DougStroud

Well-known Member
Joined
Aug 16, 2005
Messages
2,956
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
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
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,870
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,956
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,915
Messages
5,545,016
Members
410,646
Latest member
LegenDSlayeR
Top