Excel how do I add a flat 10.00 in a column with 10 entries

S

SVC

In a blank cell type 10, then copy the cell. Highlight the cells to which 10
is to be added, click Edit > Paste Special and select Value and Add, then OK
 
C

Chip Pearson

Enter 10 in some empty cell and copy that cell. Then select the
number you want to change, go to the Edit menu, choose Paste
Special, select the Addition option, and click OK. You may now
delete the cell in which you entered the 10.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top