edit data in multiple cells

  • Thread starter Thread starter Ask MS
  • Start date Start date
A

Ask MS

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

Thanks!
 
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.
 
select yr cells/area, go to formula bar, insert yr data and use CTRL
+ENTER
 
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.
 
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.
 
=A1&" the same words"

use the formula for the whole region containing data on question

then Copy->PasteSpecial-as Values onto the region
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Sorting Cells 8
Multiple data entry with multiple results 2
How to add time from multiple cells & date Cells & machine type c 3
Comparison of columns using Conditional Formatting 3
Adding a pre-fix to each item in a cell 1
COUNTIF using conditions 2
How do I link multiple cells from another workbook? 2

Back
Top