How to add the same value to an entire column?
 

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?

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?

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Brita" wrote in message
...
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?