Using Excel 2013




I have 2 ranges of non-contiguous cells that all reside on the 1st page of my spreadsheet. I selected the first range, held down Ctrl, then selected the 2nd range and then set the print area. I want to be able to print both cell ranges on one page but they print on two separate pages. How can I get them to print on one page?


Your help is greatly appreciated.


Karen

Can anyone help?

I think you need to hide the columns and/or rows in between the non-contiguous ranges to get them into a single page, or you paste link them into a new sheet.

Thank you!