Excel文件打印出来的问题 [英] Excel file print out issue

问题描述

你好，

               我已经创建了包含8-10张的Excel工作簿，现在我的经理想要采取行动，所以如果有人点击打印按钮，整张纸进入一个打印
页面，所以总共8-9页现在问题是我的每张纸包含近200行和从A到Z和AA的列.....并且一张纸包含多达400行，所以当我给出打印选项时，它出来8页一页，所以总共80页!!这是巨大的和
最终用户不理解包含，因为它看起来像一个大混乱。我也尝试将其转换为PDF，但它也是一样的。请提出建议。

                I have created Excel workbook which contains 8-10 sheets, now my manager wants to take an action so if someone hit a print button the whole sheet comes into one print page so total 8-9 pages only now the problem is my each sheet contains almost 200 rows and colums from A to Z and AA..... and one sheet contains upto 400 rows so when i give print option it comes out 8 pages for one sheet so total 80 pages!! that's huge and enduser doesn't understand the contains because it looks like a big mess. I tried to convert it into PDF also but it's same thing. Kindly give suggestions.

 

推荐答案

你可能希望宏将所有工作表合并到一个新工作表中。 Ron De bruin有一个网页，说明如何做到这一点

You probably want the macro to merge all the sheet into a new worksheet. Ron De bruin has a webpage explining how to do this

 

http://msdn.microsoft.com/en-us/library/cc793964.aspx

 

如有必要，我可以提供协助。

I can assist if necessary.

这篇关于Excel文件打印出来的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！