Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing repeating columns on the same page
Not really sure how to explain this... I have three columns of information.
Each column is not very wide but the number of rows is over 200. I can make the columns where the three are less than half of the width of a printed page. What I want to do is instead of having multiple pages which are only filled halfway across I want to print two pages full size side by side... So that it looks like this: Page 1 Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Page 2 Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C I need to be able to sort ascending and descending for each column as the list is updated. So, I cannot just copy and paste into new columns... Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing repeating columns on the same page
You might find this link to David McRitchie's site covers what you
want to do: http://www.mvps.org/dmcritchie/excel/snakecol.htm Hope this helps. Pete On Jul 10, 10:18 pm, Dazed and Confused <Dazed and wrote: Not really sure how to explain this... I have three columns of information. Each column is not very wide but the number of rows is over 200. I can make the columns where the three are less than half of the width of a printed page. What I want to do is instead of having multiple pages which are only filled halfway across I want to print two pages full size side by side... So that it looks like this: Page 1 Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Page 2 Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C I need to be able to sort ascending and descending for each column as the list is updated. So, I cannot just copy and paste into new columns... Any help would be greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing repeating columns on the same page
I like to copy the data into MSWord and use MSWord's builtin ability to do
column layout. With lots of data, I sometimes have to paste into Notepad first--large tables cause me trouble in MSWord. If you're not doing many calculations, you may just want to keep your data in MSWord, too. Dazed and Confused wrote: Not really sure how to explain this... I have three columns of information. Each column is not very wide but the number of rows is over 200. I can make the columns where the three are less than half of the width of a printed page. What I want to do is instead of having multiple pages which are only filled halfway across I want to print two pages full size side by side... So that it looks like this: Page 1 Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Page 2 Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C Column A | Column B | Column C | Column A | Column B | Column C I need to be able to sort ascending and descending for each column as the list is updated. So, I cannot just copy and paste into new columns... Any help would be greatly appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I print repeating rows on every page when printing? | Excel Discussion (Misc queries) | |||
Printing: repeating columns on left and RIGHT | Excel Discussion (Misc queries) | |||
Printing: repeating columns on left and RIGHT | Excel Discussion (Misc queries) | |||
Repeating Rows and Columns on every page | Setting up and Configuration of Excel | |||
Repeating Rows and Columns on each page of print out | Excel Discussion (Misc queries) |