the format painter no longer shows the little paint brush :(

huskylord

New Member
Joined
Apr 1, 2002
Messages
7
This is a very low priority question.
(but one that's been bugging me for quite some time).
I don't know when or how or why this happened, but sometime ago, I noticed that when i drag some formatted cells with the format painter, and it comes time to copy over the format to some new cells, my mouse point stays as a mouse point as opposed to the little paintbrush. Can anyone tell me the quick fix to get it back? I've combed the Tools/Options section and found nothing.

Any help would be appreciated.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
I think you're confusing Excel with Word.
This message was edited by Mark W. on 2002-04-02 13:46
 
Upvote 0
so, you select cells, and click on the format painter and you don't get a paintbrush? or you no longer have the format painter as an option to choose from?
 
Upvote 0
here's a real stab in the dark, no matter what the issue.....go to VIEW:TOOLBARS:CUSTOMIZE:
on the commands tab, choose format
in the right hand box, scroll down to format painter. Drag the icon to the toolbar .....next to the old icon....high
light the old icon, right click and then delete it....maybe it got corrupted somehow.
 
Upvote 0
Hi Gus

FormatPainter is a MUST in Excel saves me as im lasy.. is the icon on the toolbar i guess so as you say no brush

you are ok using this ie

select cell click fPainter brush appears??? YES!
 
Upvote 0
Wi_Guy, you are the man.
I think it was corrupted somehow.
Uninstalling and reinstalling that little icon fixed it up.

thanks all !! :)
 
Upvote 0

Forum statistics

Threads
1,214,911
Messages
6,122,192
Members
449,072
Latest member
DW Draft

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top