2007 - turning off Insert Options pop-up
 

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!

2007 - turning off Insert Options pop-up
 

Laura

I'm not 100% sure what you refer to. If it is the new formatting mini bar
then it's under Office buttonExcel OptionsPersonalizeShow mini toolbar on
selection


HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Laura" wrote in message
...
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!

2007 - turning off Insert Options pop-up
 

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



"Nick Hodge" wrote:

Laura

I'm not 100% sure what you refer to. If it is the new formatting mini bar
then it's under Office buttonExcel OptionsPersonalizeShow mini toolbar on
selection


HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Laura" wrote in message
...
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!

For Excel 2007:

Office2007 buttonExcel OptionsAdvanced in Cut, copy, and paste section, uncheck "Show Insert Options button".