ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing Question (https://www.excelbanter.com/excel-discussion-misc-queries/209605-printing-question.html)

da617

Printing Question
 

I have a spread sheet in which I have selected a print area and then added
additional cells that I want printed also, exclusing other cells on the
spread sheet. However, everytime I try to print Excel prints each area or
cell as an individual sheet. It seems to me that it should be very simple for
me to pick a group, individual cells or both as a print area and leave out
what I don't want to print. It is possible for me to do this?

Bernard Liengme

Printing Question
 
Have you thought of making a 'print-only' sheet?
Use formulas such as =Sheet1!A1 to display data from one of more 'working'
worksheets
Then you can print just what you want on one paper page
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"da617" wrote in message
...

I have a spread sheet in which I have selected a print area and then added
additional cells that I want printed also, exclusing other cells on the
spread sheet. However, everytime I try to print Excel prints each area or
cell as an individual sheet. It seems to me that it should be very simple
for
me to pick a group, individual cells or both as a print area and leave out
what I don't want to print. It is possible for me to do this?




ShaneDevenshire

Printing Question
 
Hi,

The answer is no.

You have to do something like what Bernard suggested to fake it.

--
Thanks,
Shane Devenshire


"da617" wrote:


I have a spread sheet in which I have selected a print area and then added
additional cells that I want printed also, exclusing other cells on the
spread sheet. However, everytime I try to print Excel prints each area or
cell as an individual sheet. It seems to me that it should be very simple for
me to pick a group, individual cells or both as a print area and leave out
what I don't want to print. It is possible for me to do this?



All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com