How can I add a value to entire spreadsheet?

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

Guest

I have a speadsheet with numbers in the columns. I need to add the same value
to each amount in the columns. I know this can be done as I have done it
before but I cannot remember how to.

Any help would be great!
 
In a new worksheet, I would create a formula that simply adds the number you
need to each cell. Copy that formula to all the corresponding cells. The
copy all the new numbers back to the original worksheet, and use "Paste
Special, Values" to overwrite the original numbers with the new numbers.
 
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

How to sort entire spreadsheet by one column sort 5
Like data into new spreadsheet 4
move a row of data values to a column in sorted order 2
Copying down formatting 1
Conditional Formatting 3
Macro to add numbers in a text string 5
scroll automatically as data is imported into a spreadsheet 1
Formula 2

Back
Top