Hi guys, i have a bit of a problem that i can't seem to find a SOLUTION to - i want to print non adjacent cells in Excel. At the moment I'm trying to highlight a ROW hold down the CTRL key and highlight a column and then set a print area this does work but when i preview the page the row and column are printing on two separate PAGES so i tried adjusting the page setup to fit to one page but the same thing happens. Is there any way around this or what am i doing wrong someone please help me its driving me nuts.

thanks very mucha quick WORKAROUND would be to copy and past the cells next to each other then set that area as the print area.

FBOne technique you can use to resolve this problem is the Hide the column(s) between the non-adjacent columns you want to print. Then, those hidden columns will not be included in your print output.

To hide column(s), right click on the column at top to select the whole column and then select Hide. You can select multiple columns to hide them all at once.

For more detail on hiding and unhiding columns or rows, search Excel's help on hide, or unhide.