Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a long column of numbers that we add to daily. This column needs to
be sorted in ascending order and then printed. I don't know of a way to sort multiple columns together so that is why it is one long column. Is there a way to get it to print as multiple columns across a page so as to not have numerous pages with only 1 column on each? Thanks. |
#2
![]() |
|||
|
|||
![]()
take a look he
http://www.mvps.org/dmcritchie/excel/snakecol.htm In article , Sue wrote: I have a long column of numbers that we add to daily. This column needs to be sorted in ascending order and then printed. I don't know of a way to sort multiple columns together so that is why it is one long column. Is there a way to get it to print as multiple columns across a page so as to not have numerous pages with only 1 column on each? Thanks. |
#3
![]() |
|||
|
|||
![]()
Another option is to use MSWord.
You could copy the data from excel to word and use Format|columns to make it look pretty. Heck, you may even be able to just keep the data there and update it in place. Sue wrote: I have a long column of numbers that we add to daily. This column needs to be sorted in ascending order and then printed. I don't know of a way to sort multiple columns together so that is why it is one long column. Is there a way to get it to print as multiple columns across a page so as to not have numerous pages with only 1 column on each? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) | |||
Word wrap | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
toe wrap columns | Excel Worksheet Functions | |||
HOW CAN I WRAP TEXT IN A ROW WHEN PRINTING A LONG ROW | Excel Discussion (Misc queries) |