Quick Excel Copy&Paste Question
Just got a new laptop and can't figure out how to change this setting...
In Excel 2016, how do I set it so when I copy picture as shown when printed, my numbers get changed to black and white, but my title cells and other things are kept in color?
Thanks!
Are you copy pasting into a PowerPoint, a word document? If so, you can paste special as an enhanced metafile. That should do the trick.
Not entirely sure if there's an option but you can create a 'paste switch' basically have a cell that's linked to a conditional formatting rule where if it's set to '1', have all the cells highlighted (you'd have to highlight the area you want to change) change font to black.
By setting up a switch you can always switch back and forth.
Hope this helps
Culpa quo esse architecto quae. Placeat molestiae mollitia consequatur minima neque at. Recusandae architecto qui quo.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...