Home |
Search |
Today's Posts |
#1
|
|||
|
|||
colums in xcel
Hi group newbie here
I have a list of names and telephone numbers of over 300 people the data only forms 2 cells per entry so is quite small what I want to do is to a 'wrap' facility on each page, so the data is displayed in 2 colums on each page, thus saving space when pronting the data, making sure that the list is still in alphabetical order on each page, spreading over the 2 colums, then continuing on the next page, is this possible? TIA |
#2
|
|||
|
|||
MSWord has this ability built in.
You should be able to copy your two column range into word, then use word's built in Format|Columns to make it print nice. And you can sort lists within msword. **- kingdom -** wrote: Hi group newbie here I have a list of names and telephone numbers of over 300 people the data only forms 2 cells per entry so is quite small what I want to do is to a 'wrap' facility on each page, so the data is displayed in 2 colums on each page, thus saving space when pronting the data, making sure that the list is still in alphabetical order on each page, spreading over the 2 colums, then continuing on the next page, is this possible? TIA -- Dave Peterson |
#3
|
|||
|
|||
one way to do it is to have a Display or print page and a data page
if on your data page the information in in columns A and B and you Call the page Data format the sheets on your display page and where you want the names put =indirect("Data!A2") and next to it =indirect("Data!B2") do this same think for each of the locations you want the names and addresses. because of the not wanting to retype in each cell you might make the equaitions be something like =indirect("Data!A"&(Row()-4)) if your first row for display were 6 and your first data row were 2 the next column of data would be if 25 names were in the first column =indirect("Data!A"&(Row()+21)) "**- kingdom -**" wrote: Hi group newbie here I have a list of names and telephone numbers of over 300 people the data only forms 2 cells per entry so is quite small what I want to do is to a 'wrap' facility on each page, so the data is displayed in 2 colums on each page, thus saving space when pronting the data, making sure that the list is still in alphabetical order on each page, spreading over the 2 colums, then continuing on the next page, is this possible? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i want my excel colums to be rows | Excel Worksheet Functions | |||
How do I export an Adobe document to Xcel? | Excel Discussion (Misc queries) | |||
Why won't colums add if new infor mation is added? | Excel Worksheet Functions | |||
sumif/countif on non-consecutive colums - array? | Excel Worksheet Functions | |||
How to add up a number of colums (posted on 29/10/04) | Excel Worksheet Functions |