Share via

can't print selection in some sheets

Anonymous
2012-12-03T13:12:54+00:00

I have several sheets in a excel workbook. In some sheets I can print selections and in some sheets I can't. How can I fix this problem.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2012-12-04T06:27:51+00:00

    Hi,

    Thank you for using Microsoft Community.

    I would try to assist you related to your printing issue in Excel 2013.

    Do you face this issue only with a specific Excel file and Specific sheets within the file?

    Does the selected Excel data look fine in print preview?

    What happens if you select a range and then click on Page layout, Print area and Set Print Area, now try to check if it prints the selection?

    If the issue is only with a specific file, you may copy the content of the data to a new Excel workbook and check if it works fine.

    I hope this helps. If you need any further information, you can always reply and I’ll be happy to help you.

    Thank you.

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-07-07T18:31:53+00:00

    I am having the exact same problem.

    I have written a template for my work responsibilities and the area is one to print out the report.

    It no longer works.

    What I have discovered is that if I change the paper size from 8.5x11 to 8.5x14 it shows up.

    Which makes no sense.

    I have several different tabs/sheets and some work - some don't

    Again this doesn't make sense and your simple copy and paste into another workbook is idiotic and doesn't address the problem.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2015-03-31T18:55:03+00:00

    What I have discovered is that if I change the paper size from 8.5x11 to 8.5x14 it shows up.

    Which makes no sense.

    I found that Excel was wanting to use the Bypass tray on my printers for certain print jobs.  Print jobs from the user were stacking up unprinted in the machine, while their other non-Excel jobs went through...  The Printer's settings on the particular computer were set for "Auto" paper source selection.  I edited the printer's default settings from the Devices and Printers > Printer Properties  section and manually set the default to Tray 1 (which is 8.5x11).  Problem solved.  Weird

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2013-06-13T18:54:16+00:00

    You used to be able to highlight an area and "print selection."  Is that no longer an option?  I don't want to have to set a print area just to print this one little section.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2012-12-12T09:27:47+00:00

    I ended up copying one sheet to another. That got the printing working. I did try to set the print area prior to asking my question, that didn't work either. Anyway now I know what I have to do in the furture.

    Thanks

    Joe

    Was this answer helpful?

    0 comments