Formatting a datbase

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

king met - 29 Nov 2007 00:52 GMT

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 jeffreythies@gmail.com

Reply to this Message

Gord Dibben - 29 Nov 2007 01:14 GMT

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

>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 jeffreythies@gmail.com

Reply to this Message

David Biddulph - 29 Nov 2007 04:28 GMT

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.]

Signature

David Biddulph

> 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 jeffreythies@gmail.com

Reply to this Message