Printing out multi columns in excel

[jupops]

Hi All

I have a quick question, which most likely is a easy answer. If you have created an excel sheet with either 2, 3 4 columns and so on how can you fill the sheet up, before moving onto page 2, thus saving paper. I have done this via copying the data into word, then formating it into columns. I would like to know if this can be done in excel using vba coding or by any other method.

Thank You
Jupops

 

[mscallisto]

I'm not sure I understand the problem...can you provide a better example?

 

[jupops]

Hi I hope this is a better explanation. If you get data for a new spreadsheet, which may look like:

No Item Qnt
1 120-111 45
2 120-122 123
3 144-456 55

and so until the number in column 1 is 7895. this will only fill in the first three columns on the sheet thus when printing will leave a lot of space and waste a lot of paper. I was hoping to to see if a macro could see when the first set of columns (no, Item, Qnt) reach the end of a page and see if there is room left to move the next column data next to it with maybe a cell to seperate the columns, eg


No Item Qnt No Item Qnt
1 120-111 45 85 120-122 123
3 144-456 55 86 120-111 45
2 120-122 123 87 144-456 55

and so on....

Sometimes you only need two columns in a set to work with (Item, Qnt), so you may get three sets of columns on a page, I hope this makes it a little clearer.

Regards
Jupops

 

[mscallisto]

Well the answer is probably yes but there are a lot of variables that can make this a complex piece of vba code that would work all the time.

If all columns were always the same size in characters, same font, same font size, same column width etc., it would be easier.

If for example, your above sample could stay somewhat constant like I described above I believe it could probably be done in a few loops. You could create six or nine columns from three columns for each page (maybe 60 rows deep) and continue until you run out of rows.

 

[mscallisto]

Actually there is another thing you can try to "save paper"

I was in thread68-577439 where it was pointed out to me that you can print multiple pages on one page.

Check it out and see if it helps before you invest time and effort in code.

Also note that the thread is about "Word" but the same thing can be done in Excel.

I did the following:
File > Print > Properties > pages per sheet