| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy & paste formulas while referring to same cells
I'm trying to copy a group of calculations (say A1 to A10) to another
location in the same workbook (say D11 to D20) while having the cells referred to by the calculations stay the same. For ex., I want the calculation 'B1+C1' in cell 'A1' to still refer to 'B1' & 'C1' when it is moved to 'D11' (usually the calc would refer to cells 'B11' & 'C11'). Can I do this without having to use $'X'$'#' ?. Is there a keyboard shortcut? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| copy worksheet to a new workbook with formulas .... but new file not point to old one | Excel Discussion (Misc queries) | |||
| Creating a macros to copy and paste cells | Excel Discussion (Misc queries) | |||
| fairly easy (i thought) copy and paste cells, increment by 17 accross | Excel Discussion (Misc queries) | |||
| how to copy formulas to other cells in excell | Setting up and Configuration of Excel | |||
Threaded Mode
