View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default 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!