MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Inserting data into blank & non blank cells at same time


Posted by craig on May 03, 2001 10:26 AM

I have a group of cells that I want to add a numerical value to.
i.e. I want to add the value $5.00 to cells A1:A4
A1,A4 have no number in it so their final value should be $5.00 per cell
A2 has $2.00 in it so it's final value should be $7.00
A3 has 1:50 in it so it's final value should be $6.50
I would like to bev able to select all the cells at once and enter the constant number.
Any ideas?¿


Posted by Mark W. on May 03, 2001 11:31 AM

Enter 5 into an unused cell. Copy it. Select
cells A1:A4, and do a Paste Special... Values.
Click the "Add" Operation radio button.

Posted by CRAIG on May 03, 2001 11:36 AM

Thanks Mark W. I new there had to be a simple way to go about that!