Format Painter won't stay on

L

Lynn

I double click the format painter & use it once & then it shuts off. How can
I get it to stay on til I turn it off?
 
N

Niek Otten

Click once and it will "shut off" after one use. Double-click and it should
stay on.

No other problems with double-clicks?
 
N

Niek Otten

<Is there an option that I need to set?>

Not that I know of. But I think this option has not always been present in
Excel. Do you happen to use an old version?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Lynn said:
No other problems with double click. Is there an option that I need to
set?
Click to expand...
 
B

Bob Umlas

There may be a macro running when you change selection - right-click the
sheet tab, select View Code, and see if there's any code on the
Worksheet_SelectionChange event
Bob Umlas
Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

When trying to make next word into bold font, it boldens the word before. 0
E-mails disapair from trash 0
Format Painter overwrites text 6
Arabic ligatures In MS Word 2019 1
Excel opening 1
OneNote is great but why is there no Format Painter tool? 3
Automatic Emails sent to my Contact Groups by Microsoft 1
Format column widths from one table to a separate table on same page 1

Top