How to add the same value to an entire column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Special>Add>OK>Esc.

Delete the value cell.

Gord Dibben Excel MVP
 
Put value in cell, copy cell, select data and do Edit / Paste Special / Values
and Add
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can only delete an entire row not a cell in excel 2013? 1
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Duplicates Deletion ? 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Insert a function in an entire column 3
How to sort entire spreadsheet by one column sort 5
Conditional Formatting an Entire document 1
Adding different value error bars to each column of the SAME serie 1

Back
Top