edit data in multiple cells

[Ask MS]

How can I add same words/data into multiple non-blank cells at the same time?

Thanks!

 

[John C]

Select all cells that you are entering the identical data into.

Type the data (should appear in the first cell selected), then press
CTRL+ENTER.

 

[Jarek Kujawa]

select yr cells/area, go to formula bar, insert yr data and use CTRL
+ENTER

 

[Ask MS]

Thanks for your answer. But my question is, if those multiple cells have data
contents already, and I want to add the same words after the data in each of
the multiple cells, what should I do?

Thanks.

 

[John C]

If all of these are going to have the same data at all times, just have one
cell be the one you edit, i.e.: A1, and have all other cells have the formula
=$A$1, and then any change you make in A1 will be carried through all other
cells.

 

[Jarek Kujawa]

=A1&" the same words"

use the formula for the whole region containing data on question

then Copy->PasteSpecial-as Values onto the region