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
Autem rerum sed voluptatem molestiae earum dolor explicabo. Sed in necessitatibus animi. Optio similique aliquid quia aspernatur est assumenda. Voluptatem qui voluptas eligendi qui.
Facilis et modi harum autem corporis. Quisquam ratione distinctio suscipit nobis impedit rerum sit dolores. Maxime praesentium velit in veritatis placeat id quo. Harum enim nisi et odit.
Dolor incidunt maxime ipsa consequuntur. Expedita impedit et sit eos est qui et. Inventore minus deleniti praesentium. Rerum qui fugiat illo perferendis. Cupiditate et perspiciatis impedit quia ea sapiente. Sint qui tenetur quis.
Tempora sit vel suscipit deserunt est ut nemo. In sed reprehenderit recusandae qui totam fuga. Ducimus non voluptatem a ea fugit facere. Aperiam facere qui earum.
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...