Formatting a datbase
 

can anybody help me? i started a database in excel but need to reformat it.
all the database info spreads across three pages and i need to m ove it so
thay stack in three columns on one 8.5 by 11 page. so the company is one
line, phone the next, address the next, and so on. how do i do this.
thanks email me at

Formatting a datbase
 

Stacking may just be a matter of tranposing but hard to tell from your
description.

How is your data laid out currently?

Across 3 pages could be 18 or 20 columns and down many rows.

How many columns and rows and what would be combined to get it to fit into 3
columns on one page?


Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 16:52:02 -0800, king met <king
wrote:

can anybody help me? i started a database in excel but need to reformat it.
all the database info spreads across three pages and i need to m ove it so
thay stack in three columns on one 8.5 by 11 page. so the company is one
line, phone the next, address the next, and so on. how do i do this.
thanks email me at

Formatting a datbase
 

You may wish to look at MS Word's mail merge facility for producing labels,
which can use an Excel sheet as the data input. Details in Word help.

[And if you ask a question in a newsgroup, you get the answer in the
newsgroup, not by e-mail. That way, other people can see the answer in the
group archive if it is useful to them, and also the answer can be corrected
or improved by other members of the group.]
--
David Biddulph

"king met" <king wrote in message
...
can anybody help me? i started a database in excel but need to reformat
it.
all the database info spreads across three pages and i need to m ove it so
thay stack in three columns on one 8.5 by 11 page. so the company is one
line, phone the next, address the next, and so on. how do i do this.
thanks email me at