How to add the same value to an entire column?

B

Brita

I can't remember how & I've tried everything. I have a price list in column
form & want to add the same value to every cell. How is this done?
 
G

Gord Dibben

Brita

Enter the value in a cell.

Copy that cell then select the price list range and Paste Special>Add>OK>Esc.

Delete the value cell.

Gord Dibben Excel MVP
 
K

Ken Wright

Put value in cell, copy cell, select data and do Edit / Paste Special / Values
and Add
 
Top