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!
|