New to group and excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The BusyHighLighter - 23 Jul 2007 14:40 GMT

Hello,

I'm new to this forum and have a question about repeating things in cells.
How can I paste the contents of one cell into more than one cell?

I'm trying to make an address book and take the state abbreviation into
several cells.

Thank you!

Reply to this Message

Ron de Bruin - 23 Jul 2007 15:47 GMT

Hi BusyHighLighter

If you select for example A1:A10 and enter some text you can use Ctrl Enter to fill all
cells with your text.
Another way is to copy the cell and paste it in the other cells

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Hello,
>
[quoted text clipped - 5 lines]
>
> Thank you!

Reply to this Message

The BusyHighLighter - 23 Jul 2007 16:16 GMT

Thank you, this helped and I got it to work on a couple of columns.

Sometimes when I try to do this, however, it states that the data in the
cell I am copying into the other cells is not the same size (it's one cell
going into multiple cells).

??

> Hi BusyHighLighter
>
[quoted text clipped - 11 lines]
> >
> > Thank you!

Reply to this Message

Peo Sjoblom - 23 Jul 2007 16:22 GMT

Do you have merged cells, if so unmerge them. Since you are new at Excel it
would save you a lot of future headache if you avoid using merged cells

Signature

Regards,

Peo Sjoblom

> Thank you, this helped and I got it to work on a couple of columns.
>
[quoted text clipped - 21 lines]
>> >
>> > Thank you!

Reply to this Message

JLatham - 01 Aug 2007 04:22 GMT

To expand on what Peo Sjoblom said: don't use merged cells unless you
absolutely have to. Most people seem to use them to set up some kind of long
title or caption over or under another row of cells occupying several
columns. A way around that is to enter the caption in the leftmost cell of
the group you are thinking about merging and after entering it, select the
cells that you would have merged and...
Then choose
Home tab, Cells group, click on arrow on Format then choose Format Cells (at
the bottom of the list) then select the [Alignment] tab on the dialog that
opens, and under Text Alignment in Horizontal there is an entry: "Center
Across Selection", choose that and it will look as if you've merged the
cells, but you really didn't.

Welcome to the Wonderful, Wacky World of Microsoft Excel.

> Thank you, this helped and I got it to work on a couple of columns.
>
[quoted text clipped - 19 lines]
> > >
> > > Thank you!

Reply to this Message