| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
prevent changes to cell references when copying and pasting
I have an Excel workbook where cells in a column in Sheet 2 refer to the
corresponding cell in Sheet 1. However, when my colleages cut and paste data in Sheet 1, it creates #ref errors in the second sheet where the formulae adapt to the moving cells. There must be a way where I can lock the formulae so when data is moved out of a cell, the formula doesn't "follow" it. Any ideas? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Spreadsheet with Cell References Into A Different Workbook | Excel Discussion (Misc queries) | |||
| How to control cell references when copying a formula? | Excel Discussion (Misc queries) | |||
| Prevent Row Height from increasing when Pasting lenghthy text into Cell. | Excel Worksheet Functions | |||
| Copying and Pasting a cell with a constant number | Excel Worksheet Functions | |||
| Copying linked cell references. | Excel Worksheet Functions | |||
Threaded Mode
