Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Long Columns
I have a long column of numbers which I want to print.
Is there a way of printing so that more that i can get three or four pages of my column on one page and save paper? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Long Columns
hi
excel does not have a built in function to do this but this is a common request that many users have and has been addressed at this forum before. see this post from gord dibbon from about a week ago... http://thesource.ofallevil.com/commu...&cr=&sloc=&p=2 regards FSt1 "Vaughan" wrote: I have a long column of numbers which I want to print. Is there a way of printing so that more that i can get three or four pages of my column on one page and save paper? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Long Columns
You can use worksheet functions or a macro.
In B1 enter this formula................ =INDEX($A:$A,(ROWS($1:1)-1)*4+COLUMNS($A:B)-1) Will return 1,2,3,4 5,6,7,8 etc. Copy across to Column E then select B1:E1 and copy down untill you get zeros. With a macro......................... Public Sub SplitToCols() Dim NumCols As Integer Dim i As Integer Dim colsize As Long On Error GoTo fileerror NumCols = InputBox("Choose Final Number of Columns") colsize = Int((ActiveSheet.UsedRange.Rows.Count + _ (NumCols - 1)) / NumCols) For i = 2 To NumCols Cells((i - 1) * colsize + 1, 1).Resize(colsize, 1).Copy Cells(1, i) Next i Range(Cells(colsize + 1, 1), Cells(Rows.Count, 1)).Clear fileerror: End Sub Gord Dibben MS Excel MVP On Thu, 4 Sep 2008 06:21:02 -0700, Vaughan wrote: I have a long column of numbers which I want to print. Is there a way of printing so that more that i can get three or four pages of my column on one page and save paper? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
making multiple columns when printing long datasheet | Excel Discussion (Misc queries) | |||
HOW CAN I WRAP TEXT IN A ROW WHEN PRINTING A LONG ROW | Excel Discussion (Misc queries) |