Copy formula

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

Guest

I have data in multiple columns, I want to copy a formula that increases
current data by 10%. I cannot insert additional rows to compute the formula.
Without having to go into each cell and enter *1.10, how can I get that
formula part to copy across the columns?

:)
 
put 1.1 in an empty cell, copy it, Select all the data cells to be
affected, Edit, Paste Special, Select the Operation Multiply, and click OK.
 
thank you very much!

Bob I said:
put 1.1 in an empty cell, copy it, Select all the data cells to be
affected, Edit, Paste Special, Select the Operation Multiply, and click OK.
Click to expand...
 

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

Excel Help to copy information from one row at a time to another sheet 1
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
Copy formula 6
Quick way to fill formulas? 2
automatically numbering rows 2
Is a Nested Formula what I need? 1
VBA code copying formula not running correctly 3
Macro to fill down automatically the number of rows in a spreadsheet 1

Back
Top