Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New to group and excel
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New to group and excel
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "The BusyHighLighter" <The wrote in message ... 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! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New to group and excel
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). ?? "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "The BusyHighLighter" <The wrote in message ... 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! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New to group and excel
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 -- Regards, Peo Sjoblom "The BusyHighLighter" wrote in message ... 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). ?? "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "The BusyHighLighter" <The wrote in message ... 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! |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New to group and excel
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. "The BusyHighLighter" wrote: 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). ?? "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "The BusyHighLighter" <The wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
I wish to group my worksheets under group tabs | Excel Worksheet Functions | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions |