PRINTING RANGES IN EXCEL
I tried printing non-contagious ranges in excel but each range appeared in a separate page which is not what I want. How can I have the ranges in the same page without copying and pasting in another worksheet?
Thanks.
Software
I tried printing non-contagious ranges in excel but each range appeared in a separate page which is not what I want. How can I have the ranges in the same page without copying and pasting in another worksheet?
Thanks.
by russ werner
by shanghai sam
by dklippert
Even though I hate to ever say it, you can't.
One way around it is to use the picture function.
Go to Tool>Customise. On the Commands tab choose Tools and scroll down on the right untill you find the camera icon. Drag it onto one of the toolbars.Now highlight the first range click on the Camera icon then switch to an empty spreadsheet. Click on a cell. Go back and do the same thing with the other ranges. The Camera creates a dynamic picture that changes when the data changes.
by shanghai sam
by muhammaduna
This discussion is closed to new replies.
Sort by Trending