View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
 
Posts: 284
Default How do I turn off format painter so it doesn't keep popping up?

mcandrj

Depending on the version, but in pre xl2007 I would go to the right end of
the standanrd tool bar and look for the drop down arrow. Upon selection of
this arrow I would remove the check mark from the formate painter. This will
remove it (Hide it) from displaying on the standard tool bar. If you are
just tryiing to cancel the formating mode just click on the paint brush icon
on the tool bar.

Mike Rogers

"mcandrj" wrote:

Is there an option to hide or cancel the format painter?