edit data in multiple cells
 

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

Thanks!

edit data in multiple cells
 

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.
--
John C


"Ask MS" wrote:

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

Thanks!

edit data in multiple cells
 

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

edit data in multiple cells
 

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" wrote:

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.
--
John C


"Ask MS" wrote:

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

Thanks!

edit data in multiple cells
 

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.
--
John C


"Ask MS" wrote:

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" wrote:

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.
--
John C


"Ask MS" wrote:

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

Thanks!

edit data in multiple cells
 

=A1&" the same words"

use the formula for the whole region containing data on question

then Copy-PasteSpecial-as Values onto the region