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
Exercitationem esse odit voluptatem qui itaque quae nulla. Qui et odit accusamus non ipsam. In dicta ipsa iure hic suscipit tempore.
Nobis aut modi necessitatibus voluptatum voluptatum et voluptatibus libero. Autem aliquid quis velit ipsum in. Minus ratione esse quas quo.
Maxime dolorem nulla dolores enim consequuntur. Inventore blanditiis quam sit deleniti ducimus qui. Voluptatibus facere error beatae perferendis velit. Nobis debitis optio facilis maiores eos vero magni. Voluptas et delectus provident dolores.
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...