Tôi không hiểu bạn muốn hỏi gì nữa ?! Bản thân excel nó đâu có in những trang không có dữ liệu (theo đúng nghĩa đen của nó). Ví dụ, từ một sheet trắng chẳng có gì, bạn thử ấn lệnh Print thử xem. Có phải Excel nó báo lỗi như thế này không: Show
Microsoft Office Excel did not find anything to print. Ví dụ thứ hai, bạn gõ thử vài trang có dữ liệu và in ra thử xem, Excel nó có in cả 65536 dòng ra đâu! Nói tóm lại là tôi không hiểu ý của bạn là gì ?  volgaThành viên tiêu biểu
bạn đưa cái file đó lên và nói muốn in gì đi .lúc đó mới hiểu . thân .
Ý của bạn binhson2002 có thể là: "dữ liệu" ở đây là những số, chữ bạn đó "nhìn thấy". Bởi đôi khi file excel chứa name rác hoặc công thức sẵn thì đương nhiên excel sẽ hiểu đó là vùng chứa dữ liệu nhưng bạn đó lại chỉ muốn in vùng "nhìn thấy" mà thôi. Không biết có phải vậy không? On the first tab titled "LobbyTimeDetail", I am not able to print any pages past page 46. This first tab is a pivot table. I have checked the print range but pages 47-83 are in the print range. These pages also do not show up under print preview. I can print when I highlight a single page and "print selection" but I am not able to print the specific page using print range from the print prompt without getting the error. Has anyone encountered this issue? Any ideas on how to fix? -Matt Last edited by mattgentz; 08-08-2013 at 03:58 PM.Reason: Issue Resolved
Just right-click on the worksheet tab. Then click "Move or Copy..." On the next window click "Cancel" That's all ! When go to "Print preview" you can see worksheet data and print normally. Re: "Microsoft Office Excel did not find anything to print" - printing errorI couldn't make the % change work, but greenn's trick solved the puzzle with two easy clicks. Thanks! -
When you click on �Print� in Excel you will get the print dialog window. Make sure that the page selection (i.e., 2-2 or 3-5) numbers are cleared. If it is not cleared and you want to print a highlighted selection at the same time that you have page numbers in place you will get the error message shown above. The printer does not know what you want; specific page numbers or the selection. You can�t have it both ways. It is one or the other, printing specific page(s); or printing a selection. Microsoft should have detected this conflict and made the error message more meaningful. -05-11-2020, 11:05 AM Re: "Microsoft Office Excel did not find anything to print" - printing errorError Message: Microsoft didn�t find anything to print. When you click on �Print� in Excel you will get the print dialog window. Make sure that the page selection (i.e., 2-2 or 3-5) numbers are cleared. If it is not cleared and you want to print a highlighted selection at the same time that you have page numbers in place you will get the error message shown above. The printer does not know what you want; specific page numbers or the selection. You can�t have it both ways. It is one or the other, printing specific page(s); or printing a selection. Microsoft should have detected this conflict and made the error message more meaningful. You have responded to a question that is 7 years old and has been solved. Please have a look at some of our new posts to see where folks need help. Given that we have had three members post their first (and so far, only) posts here after the thread was marked SOLVED, I am going to close this. |
