paste same word in all cells in column

Thank You very much Mart. Now what means Fill Formatting Only or Fill
Without Formatting?
Sol
"Mart" wrote in message
...
Select the first cell and type the 'word'. The cell box will highlight
Left click the bottom right hand corner 'dot'
The cursor will change from a large + to a small +
Drag (Up or Down) to the last required cell and release the LH mouse
button.

The 'word' will be duplicated to all the required cells.

HTH

Mart


"S1L1Y1" wrote in message
...
I posted this question in the Office group but got no response.
I am working in Microsoft Excel. Now I want to add to each cell in the
column the same word. How can I do it?
Sol

I tried it but what is happing is, in the original cell each cell has
something else now with this process all the cells will have the same.
Sol
"Mart" wrote in message
...
Select the first cell and type the 'word'. The cell box will highlight
Left click the bottom right hand corner 'dot'
The cursor will change from a large + to a small +
Drag (Up or Down) to the last required cell and release the LH mouse
button.

The 'word' will be duplicated to all the required cells.

HTH

Mart


"S1L1Y1" wrote in message
...
I posted this question in the Office group but got no response.
I am working in Microsoft Excel. Now I want to add to each cell in the
column the same word. How can I do it?
Sol

I tried it but what is happing is, in the original cell each cell has
something else now with this process all the cells will have the same.
Sol
"Mart" wrote in message
...
Select the first cell and type the 'word'. The cell box will highlight
Left click the bottom right hand corner 'dot'
The cursor will change from a large + to a small +
Drag (Up or Down) to the last required cell and release the LH mouse
button.

The 'word' will be duplicated to all the required cells.

HTH

Mart


"S1L1Y1" wrote in message
...
I posted this question in the Office group but got no response.
I am working in Microsoft Excel. Now I want to add to each cell in the
column the same word. How can I do it?
Sol

Hmm... I guess you are working with an existing worksheet rather than a
fresh one. If so, it might depend on exactly what the author of the original
worksheet was doing and how he'd set-up the format. The 'solution' I gave
was for a clean worksheet.

Try the format option, see also the Help option - there may clues there.
Google might even help further.

Mart



"S1L1Y1" wrote in message
...
I tried it but what is happing is, in the original cell each cell has
something else now with this process all the cells will have the same.
Sol
"Mart" wrote in message
...
Select the first cell and type the 'word'. The cell box will highlight
Left click the bottom right hand corner 'dot'
The cursor will change from a large + to a small +
Drag (Up or Down) to the last required cell and release the LH mouse
button.

The 'word' will be duplicated to all the required cells.

HTH

Mart


"S1L1Y1" wrote in message
...
I posted this question in the Office group but got no response.
I am working in Microsoft Excel. Now I want to add to each cell in the
column the same word. How can I do it?
Sol

Hmm... I guess you are working with an existing worksheet rather than a
fresh one. If so, it might depend on exactly what the author of the original
worksheet was doing and how he'd set-up the format. The 'solution' I gave
was for a clean worksheet.

Try the format option, see also the Help option - there may clues there.
Google might even help further.

Mart



"S1L1Y1" wrote in message
...
I tried it but what is happing is, in the original cell each cell has
something else now with this process all the cells will have the same.
Sol
"Mart" wrote in message
...
Select the first cell and type the 'word'. The cell box will highlight
Left click the bottom right hand corner 'dot'
The cursor will change from a large + to a small +
Drag (Up or Down) to the last required cell and release the LH mouse
button.

The 'word' will be duplicated to all the required cells.

HTH

Mart


"S1L1Y1" wrote in message
...
I posted this question in the Office group but got no response.
I am working in Microsoft Excel. Now I want to add to each cell in the
column the same word. How can I do it?
Sol

On Mon, 4 May 2009 19:51:35 -0400, "S1L1Y1" put
finger to keyboard and composed:

I posted this question in the Office group but got no response.
I am working in Microsoft Excel. Now I want to add to each cell in the
column the same word. How can I do it?
Sol

I'm only an occasional Excel user but here are some suggestions.

Create a new column, say Y.

Copy the data in the column you want to modify, say X, to the new
column.

Select cell X1 and add the following formula:

=Y1&"text"

Then r-click cell X1 and select Copy.

Select the remaining cells in column X and select Edit-Paste (or
Ctrl-V).

Unfortunately you won't be able to delete the contents of column Y
because the data in X are dependent on the contents of Y.

One other way that is a bit more complicated is to create a new column
to the right of the subject column. Put your "text" in each cell of
the new column. Then save the spreadsheet as a CSV file (comma
delimited).

Use an editor to Search and Replace each occurrence of ...

,text,

.... in the CSV file with ...

text,

.... and then reimport this modified CSV file into a new spreadsheet.

You may lose any formulae doing it this way. If so, then restrict your
work to the subject column only.

- Franc Zabkar
--
Please remove one 'i' from my address when replying by email.

On Mon, 4 May 2009 19:51:35 -0400, "S1L1Y1" put
finger to keyboard and composed:

I posted this question in the Office group but got no response.
I am working in Microsoft Excel. Now I want to add to each cell in the
column the same word. How can I do it?
Sol

I'm only an occasional Excel user but here are some suggestions.

Create a new column, say Y.

Copy the data in the column you want to modify, say X, to the new
column.

Select cell X1 and add the following formula:

=Y1&"text"

Then r-click cell X1 and select Copy.

Select the remaining cells in column X and select Edit-Paste (or
Ctrl-V).

Unfortunately you won't be able to delete the contents of column Y
because the data in X are dependent on the contents of Y.

One other way that is a bit more complicated is to create a new column
to the right of the subject column. Put your "text" in each cell of
the new column. Then save the spreadsheet as a CSV file (comma
delimited).

Use an editor to Search and Replace each occurrence of ...

,text,

.... in the CSV file with ...

text,

.... and then reimport this modified CSV file into a new spreadsheet.

You may lose any formulae doing it this way. If so, then restrict your
work to the subject column only.

- Franc Zabkar
--
Please remove one 'i' from my address when replying by email.

Copy, then RightClick, Paste Special and Values will create a new column
that isn't dependant on the formula.
--
Jeff Richards
MS MVP (Windows - Shell/User)
"Franc Zabkar" wrote in message
...
snip

Unfortunately you won't be able to delete the contents of column Y
because the data in X are dependent on the contents of Y.

Copy, then RightClick, Paste Special and Values will create a new column
that isn't dependant on the formula.
--
Jeff Richards
MS MVP (Windows - Shell/User)
"Franc Zabkar" wrote in message
...
snip

Unfortunately you won't be able to delete the contents of column Y
because the data in X are dependent on the contents of Y.

On Wed, 6 May 2009 11:36:50 +1000, "Jeff Richards"
put finger to keyboard and composed:

Copy, then RightClick, Paste Special and Values will create a new column
that isn't dependant on the formula.

Thanks so much!

- Franc Zabkar
--
Please remove one 'i' from my address when replying by email.