It will be a list that changes frequently that I will have to put in alphabetical order as I update. I want the column to go to the bottom of the page and then overflow into the column next to it so it all prints on one page (like in a newspaper) instead of being one long column that prints out on multiple pages in a single column.
2006-12-22 07:57:01 · 4 answers · asked by rsf 3 in Computers & Internet ➔ Software
My solution works, but you have to adjust the numbers to fit your own page setup. You can do that by selecting Page Setup from the file menu and clicking OK. That will show you what cells will appear on what pages.
Start by entering in all of your data in column A. Then in column B, type this formula:
=IF(A50<>"",A50,"")
but change the two A50 references to be the first cell in column A on the second page. Copy the formula down to the bottom of the first page. In column C, type the same formula again, but changing the A50 references to be the first cell in column A on the second page. Copy the formula down to the bottom of the first page too. Repeat this procedure with as many columns as fit on your page. Now all you need to do is sort/edit column A and you can print it all by printing page 1 to 1.
2006-12-22 08:41:02 · answer #1 · answered by nospamcwt 5 · 0⤊ 0⤋
The first answer is correct, in that you can scale an Excel file to one page by simply goin to the print setup choosing to print it as 1 wide by 1 long and have it shrink to fit. The catch to this is that Excel is not designed to print like a newspaper. It thinks in rows and columns only and according to it, every column goes on forever. If you want to create the newspaper effect you will need to monitor the length of your list, and when the scaling makes your text small enough to be an eyesore, that is a cue to cut and paste half the column right next to the first one and scale again. This will work for a short while, and whether to choose portrait or landscape to print will depend on the width of your columns. Good luck.
2006-12-22 16:08:56 · answer #2 · answered by Curtis H 3 · 1⤊ 0⤋
I don't think Excel is going to let you do this. The work-around I'd use is to break your column into smaller columns like a-d, e-g, h-k etc. That way you can alphabetize each column and have them spread across your sheet and they'll be in the order and format you want. Chances are high that you will have to play around with the column length to get them all even. But once you get there it should be smooth sailing.
2006-12-22 16:14:34 · answer #3 · answered by allisoneast 4 · 1⤊ 0⤋
Go to file and then "Print Setup" which would give you the printing settings. Under the subtitle "Scaling" Click the option "Fit to:" and select one page.
2006-12-22 16:02:25 · answer #4 · answered by Anonymous · 1⤊ 0⤋