View Single Post
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Brita

Enter the value in a cell.

Copy that cell then select the price list range and Paste SpecialAddOKEsc.

Delete the value cell.

Gord Dibben Excel MVP

On Tue, 21 Dec 2004 16:47:02 -0800, "Brita"
wrote:

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?