Disable format painter in excel 2003
 

The format painter icon keeps appearing when I add or delete columns and rows
- it keeps blocking me from seeing what is in the cell and is a general
nuisance. I do not need the format painter, but I cant seem to find a way to
deactivate it, permanently if possible. Anyone have any ideas?

Actually it is probably not the Format Painter, but the Insert Options button
that is bothering you.

ToolsOptionsEdit.

Uncheck the Insert Options and for me, also the Paste Options button.


Gord Dibben Excel MVP



On Mon, 7 Feb 2005 15:43:04 -0800, tenchsama
wrote:

The format painter icon keeps appearing when I add or delete columns and rows
- it keeps blocking me from seeing what is in the cell and is a general
nuisance. I do not need the format painter, but I cant seem to find a way to
deactivate it, permanently if possible. Anyone have any ideas?