Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Printing Problem in Excel for disjointed Ranges 2
- Thread starter dvcf1n
- Start date
-
2
- #2
DaleWatson123321
Programmer
Hi,
For anyone having difficulty in printing "disjointed" ranges on ONE page, I have written a "FAQ" that describes the steps one can take to achieve this.
You can click on the "FAQ" tab at the top of the Tek-Tips page, or you can go direct to this FAQ, by clicking on this link: faq68-1161
Excel has this "hidden feature" that allows you to take a "picture" of "disjointed" ranges. It's then a matter of pasting the pictures (one-at-a-time) on a separate sheet - where you can re-size the pictures - i.e. stretch or shrink - to make them fit in the precise manner you require.
This method of placing data from different sources on ONE page, should definitely be considered for those "special" reports or forms - where you need to "present the data in a special manner", or where the different ranges of data are vastly different in terms of their column widths. Normally, it would be VERY difficult to fit such "different" types of data ranges on ONE page. It would require, for example, MUCH manipulation by "merging of cells". With this "picture" option, it is MUCH easier.
These "pictures" are unique, in that they maintain a link to the original data. This means that if and when you make changes to the original data, including inserting rows or columns, these changes will automatically be reflected in the "pictures".
Occasionally, if the range of data that one takes a picture of is too large, this can result in an error message "Picture too large" when you attempt to paste the picture.
If this happens, it's a matter of having to go back to the sheet containing the original data. Here you should do two things:
1) Decrease the font size. You might have to reduce the size significantly, perhaps down to as low as 5 or 6 points.
2) To compensate for the small font size, you should increase the "Zoom factor" - to enable you to view the data properly.
With the font size of the original data reduced, re-take the "picture", and this should then prevent you from getting the "Picture too large" error message.
I hope the above helps. If anyone encounters any problems, don't hesitate to contact me.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
For anyone having difficulty in printing "disjointed" ranges on ONE page, I have written a "FAQ" that describes the steps one can take to achieve this.
You can click on the "FAQ" tab at the top of the Tek-Tips page, or you can go direct to this FAQ, by clicking on this link: faq68-1161
Excel has this "hidden feature" that allows you to take a "picture" of "disjointed" ranges. It's then a matter of pasting the pictures (one-at-a-time) on a separate sheet - where you can re-size the pictures - i.e. stretch or shrink - to make them fit in the precise manner you require.
This method of placing data from different sources on ONE page, should definitely be considered for those "special" reports or forms - where you need to "present the data in a special manner", or where the different ranges of data are vastly different in terms of their column widths. Normally, it would be VERY difficult to fit such "different" types of data ranges on ONE page. It would require, for example, MUCH manipulation by "merging of cells". With this "picture" option, it is MUCH easier.
These "pictures" are unique, in that they maintain a link to the original data. This means that if and when you make changes to the original data, including inserting rows or columns, these changes will automatically be reflected in the "pictures".
Occasionally, if the range of data that one takes a picture of is too large, this can result in an error message "Picture too large" when you attempt to paste the picture.
If this happens, it's a matter of having to go back to the sheet containing the original data. Here you should do two things:
1) Decrease the font size. You might have to reduce the size significantly, perhaps down to as low as 5 or 6 points.
2) To compensate for the small font size, you should increase the "Zoom factor" - to enable you to view the data properly.
With the font size of the original data reduced, re-take the "picture", and this should then prevent you from getting the "Picture too large" error message.
I hope the above helps. If anyone encounters any problems, don't hesitate to contact me.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
DaleWatson123321
Programmer
P.S.
Regarding the method of dealing with the error message "Picture too large"...
My first instruction was...
1) Decrease the font size. You might have to reduce the size significantly, perhaps down to as low as 5 or 6 points.
Implicitly, reducing the font size means THEN being able to reduce the COLUMN WIDTH of all columns ...thereby enabling you to reduce the overall size - and overcome the "Picture too large" error message.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
Regarding the method of dealing with the error message "Picture too large"...
My first instruction was...
1) Decrease the font size. You might have to reduce the size significantly, perhaps down to as low as 5 or 6 points.
Implicitly, reducing the font size means THEN being able to reduce the COLUMN WIDTH of all columns ...thereby enabling you to reduce the overall size - and overcome the "Picture too large" error message.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
- Status