Printing multiple non-contiguous columns from a worksheet?

I've got an excel worksheet that I'm playing with, and I'm attempting to get multiple columns printed out onto a piece of paper. I read this thread so far: http://www.mrexcel.com/forum/excel-q...n-columns.html

I didn't understand this part: "B1 = MasterSheet!A51, etc. Drag them down, and you'll have your data formatted."

"Compiled List" is the sheet in the image that I have attached. I assume that I would make another sheet called "Printing," but I don't know how to use the formulas on the "Printing" worksheet in order to sync the column information to the "Printing" worksheet from the "Compiled List" worksheet.

The columns that I have are as follows: (A) Date applied (B) Name of Business (G) Phone Number (H) Last Time Called (I) What was said? (J) Name of Hiring Manager

I was told by Page Layout -> Print Titles that it was not contiguous.

Untitled.jpg

Hi,

From your screenshots, it looks like you want to print columns A,B,G,H,I,J. As you've discovered, Excel won't let you print non-contiguous areas. However, if the areas are A and B, then G to J, these are only two areas so there is an easy way round this:
1. Select as your print area just the information in columns G-J that you want.
2. In Page Setup, select columns A and B in the 'Columns to repeat at left' box.
3. If your G-J print area doesn't include row 1, but you want to have headings, then select row 1 in the 'Rows to repeat at top' box.
Your page setup should look something like this (this is from 2003, but it's basically the same):
Excel print left columns top row.png

If you need to print three or more areas (e.g. columns A,C,G,H,J) then you'll need to set up another sheet which takes copies of the columns you want to print and puts them next to each other.
1. Create a new worksheet called 'Print'.
2. In cell A1 of 'Print', enter ='Compiled List'!A1
3. In cell B1 of 'Print', enter ='Compiled List'!C1
4-6. In cells C1, D1 and E1, enter ='Compiled List'!G1, ='Compiled List'!H1 and ='Compiled List'!J1
7. Select cells A1-E1 of 'Print' and drag these down until you've got all the rows you need.
8. Print using the 'Print' sheet.
(This is what the instructions on the MrExcel forum were trying to say, just not as clearly as they could have)

I hope that makes sense. Good luck.
Regards,
Aardigspook