turn off auto fill options box Excel 2003
 

If I fill cells by dragging a formula down a column, Excel inserts a Fill
Option box offering a "choice of fillings" - copy, fill with format and fill
without format. Is it possible to stop this box appearing? I do not think it
was part of Office 2000.

Tools--Options--Edit tab, and uncheck Show Paste Options button.
************
Anne Troy
www.OfficeArticles.com

"martock" wrote in message
...
If I fill cells by dragging a formula down a column, Excel inserts a Fill
Option box offering a "choice of fillings" - copy, fill with format and
fill
without format. Is it possible to stop this box appearing? I do not think
it
was part of Office 2000.

Anne - Many thanks

"Anne Troy" wrote:

Tools--Options--Edit tab, and uncheck Show Paste Options button.
************
Anne Troy
www.OfficeArticles.com

"martock" wrote in message
...
If I fill cells by dragging a formula down a column, Excel inserts a Fill
Option box offering a "choice of fillings" - copy, fill with format and
fill
without format. Is it possible to stop this box appearing? I do not think
it
was part of Office 2000.