Excel ignores set print area

%3CLINGO-SUB%20id%3D%22lingo-sub-1362632%22%20slang%3D%22en-US%22%3EExcel%20ignores%20set%20print%20area%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1362632%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20completed%20my%20worksheet%20and%20set%20the%20print%20area%20and%20columns%20to%20repeat.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ExcelPageSetUp.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189423iD14B0B8947288B68%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ExcelPageSetUp.png%22%20alt%3D%22ExcelPageSetUp.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20I%20select%20Print%20and%20I%20get%20a%20blank%20-%20nothing%20to%20print%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ExcelPrint.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189424i064F72B374D06142%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ExcelPrint.png%22%20alt%3D%22ExcelPrint.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI've%20cleared%20the%20print%20area%20and%20entered%20it%20again%20-%20no%20change.%20%26nbsp%3BI've%20removed%20all%20page%20breaks.%20%26nbsp%3BIf%20I%20try%20to%20copy%20the%20data%20to%20a%20new%20workbook%2C%20I%20get%20that%20alert%3A%20%26nbsp%3BThis%20action%20won't%20work%20on%20multiple%20selections.%20I%20selected%20contiguous%20columns%20and%20rows%2C%20so%20I%20don't%20see%20how%20this%20alert%20is%20coming%20up.%3C%2FP%3E%3CP%3EI%20don't%20want%20to%20recreate%20the%20workbook.%20%26nbsp%3BAny%20thoughts.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1362632%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I've completed my worksheet and set the print area and columns to repeat. ExcelPageSetUp.png

 

Now I select Print and I get a blank - nothing to print

ExcelPrint.png

I've cleared the print area and entered it again - no change.  I've removed all page breaks.  If I try to copy the data to a new workbook, I get that alert:  This action won't work on multiple selections. I selected contiguous columns and rows, so I don't see how this alert is coming up.

I don't want to recreate the workbook.  Any thoughts.

0 Replies