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
Illum magni a repellendus porro est. Perferendis fuga sed veritatis modi. Autem iste asperiores ut enim aliquam nobis eum. Natus ea dolor error voluptatem laborum quidem voluptate. Nulla blanditiis eos non.
Asperiores dolorem amet perspiciatis quae illo et quibusdam. Consequatur perspiciatis cum ut non alias et. Ut facere nemo voluptatum est odio. Ullam laboriosam perferendis dolorum dolore rerum quibusdam est. Fuga explicabo cumque voluptatibus deserunt. Et aperiam voluptas in quisquam sunt suscipit mollitia est.
Iste eveniet voluptatem ratione optio impedit ducimus voluptatem. Voluptas deserunt dolores asperiores iusto magni expedita pariatur. Quasi minus sequi voluptatem dolor.
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...