Help with formulas for block of cells

  • Thread starter Thread starter hubcap1324
  • Start date Start date
H

hubcap1324

Hi all. I am new to the site. I need a little help.

I have a spreadsheet with pricing information for all of our products.
4 columns and 12000 rows of prices. What I need to do is to multipl
each cell by .125 without having to go to each individual cell. I di
the first cell and tried to copy and paste but it retains that value i
the pasted cell. This can't be too hard but I can't figure it out.
Thanks in advance for any help
 
Select a "new", empty cell, and format it as you wish the price cells to
display.
Enter 1.125 into this cell.
Don't worry as to the display, if it cuts off the last 5.
The cell *does* contain it's entire value, as you can see in the formula
bar.
Right click in it and choose "Copy".

Now, select all the cells that you wish to increment.
While they're still selected, right click in them an choose "PasteSpecial".
Then click "Multiply", and then <OK>.
And you're done!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi all. I am new to the site. I need a little help.

I have a spreadsheet with pricing information for all of our products.
4 columns and 12000 rows of prices. What I need to do is to multiply
each cell by .125 without having to go to each individual cell. I did
the first cell and tried to copy and paste but it retains that value in
the pasted cell. This can't be too hard but I can't figure it out.
Thanks in advance for any help.
 
Enter .125 in an unused cell.

Copy that cell.

Select the 4 columns and 12000 rows and Paste Special>Multiple>OK>Esc.

Gord Dibben Excel MVP
 
Back
Top