Home |
Search |
Today's Posts |
#1
|
|||
|
|||
split a column
Hello! I have a worksheet with only two columns but 1800 records. I would
like to print this sheet and use the least paper possible. The solution of course is to divide the two rows in multiple rows and thus filling up the paper. I would howerver like to have the records in alphabetical order on every sheet, so just cutting the rows at row 600, 1200 and 18000 doesn't do. I would very much appreciate any good idea! Thanks in advance! Pete |
#2
|
|||
|
|||
Hi Tokyogroove,
See David McRitchie's Snake Columns page at: http://www.mvps.org/dmcritchie/excel/snakecol.htm --- Regards, Norman "Tokyogroove" wrote in message ... Hello! I have a worksheet with only two columns but 1800 records. I would like to print this sheet and use the least paper possible. The solution of course is to divide the two rows in multiple rows and thus filling up the paper. I would howerver like to have the records in alphabetical order on every sheet, so just cutting the rows at row 600, 1200 and 18000 doesn't do. I would very much appreciate any good idea! Thanks in advance! Pete |
#3
|
|||
|
|||
Thank you Norman,
I will try that out tomorrow in the office! Best regards from Nippon, Pete "Norman Jones" wrote: Hi Tokyogroove, See David McRitchie's Snake Columns page at: http://www.mvps.org/dmcritchie/excel/snakecol.htm --- Regards, Norman "Tokyogroove" wrote in message ... Hello! I have a worksheet with only two columns but 1800 records. I would like to print this sheet and use the least paper possible. The solution of course is to divide the two rows in multiple rows and thus filling up the paper. I would howerver like to have the records in alphabetical order on every sheet, so just cutting the rows at row 600, 1200 and 18000 doesn't do. I would very much appreciate any good idea! Thanks in advance! Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
How do I split data in a column (formula)? | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How do I split a column having numbers and text in a random order | Excel Worksheet Functions |