How do I re-calculalate the values for all cells in a column

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

Guest

I'm a newbie to Excel worksheets however, I'm very familiar with Access.
However, I need to change data in an Excel worksheet and I'm clueless where
to start. For Example, I need to change the value of all cells in colum 3,
for all rows with data by -5, what would the formula be and where do I attach
it so that it recalulates the values in the cells. There are a little over
2000 rows so I want to do a global change.

Thanks
 
put 5 in a emty cell
mark and copy that cell
mark all cells in column 3
select inset special
select substaction
ok


"Razor" skrev:
 
Razor

No formula necessary.

Place 5 in an unused cell.

Copy that cell.

Select your Column C data range and Edit>Paste Special>Subtract<OK>Esc

Delete the cell with the 5.


Gord Dibben MS Excel MVP
 
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

Scrabble Value calculation for Welsh words 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
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
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I have a cell value define a dynamic named range? 15
Excel Concatenate with line breaks but ignore blank cells 3
Find all and Concatenate 1
Finding location (or start cell) of highest consecutive values 3

Back
Top