Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I re-calculalate the values for all cells in a column
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I re-calculalate the values for all cells in a column
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: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I re-calculalate the values for all cells in a column
Razor
No formula necessary. Place 5 in an unused cell. Copy that cell. Select your Column C data range and EditPaste SpecialSubtract<OKEsc Delete the cell with the 5. Gord Dibben MS Excel MVP On Sat, 22 Jul 2006 06:12:01 -0700, Razor wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
How sum values in column B using values in column A as the conditi | Excel Worksheet Functions |