Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel 2003 ...
I have a cell formula for sheet 2 of an excel spreadsheet that is for row 1 "=Cu!A1+Cu!A2+Cu!B1+Cu!B2", where A1, A2, B1 & B2 are numbers from sheet 1 (renamed Cu); and The formula for row 2 of sheet 2 needs to be "=Cu!A3+Cu!A4+Cu!B3+Cu!B4". If I copy the formula for row 1 and paste it into row 2, the formula shows as: "=Cu!A2+Cu!A3+Cu!B2+Cu!B3" -- which is not correct. Short of deleting every other line (which would be rather tedious as I have 140 rows and as many columns), anybody have any suggestions for formatting the formula. HELP ... the worksheets need completed by tomorrow. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copying formulas and changing cell references | Excel Discussion (Misc queries) | |||
Copying Cell Results, Not Formulas, Between Worksheets | Excel Worksheet Functions | |||
Copying formulas, relative and absolute cell references | Excel Discussion (Misc queries) | |||
copying formulas to another cell | Excel Worksheet Functions | |||
Excel: hold a reference to a single cell when copying formulas? | Excel Worksheet Functions |