2007 - turning off Insert Options pop-up

[Guest]

Using Excel 2007 and the "Insert Options" pop-up that occurs when I insert a
line is driving me batty! I've seen suggestions to go thru "Tools > Options"
but in 2007 there is not a "Tools" section, nor do I see anywhere to turn
that off in the "Excel Options" section. Has anyone been able to get rid of
it??? it blocks the data & is very frustrating!

 

[Nick Hodge]

Laura

I'm not 100% sure what you refer to. If it is the new formatting mini bar
then it's under Office button>Excel Options>Personalize>Show mini toolbar on
selection


HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Guest]

no, tried that and it still does it. I've posted a screenshot with an example:
http://www.pridmore.com/format.JPG
its very frustrating as the pop-up covers up the text to cell
Laura