| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying formula
Much appreciated, thank you very much.
-- Regards Michael Koerner "lux770" wrote in message ... Very very easy: lock the cell reference in the formula. Highlight "B2" in your formula and press F4. It will become: =IF(B1="","",ItemList!$B$2) The $ signs indicate that both the row and column references are locked. (you could also lock rows only: B$2 or columns only: $B2 by pressing F4 several times or by directly adding the $ signs in the formula.) -- lux770 ------------------------------------------------------------------------ lux770's Profile: http://www.excelforum.com/member.php...o&userid=24970 View this thread: http://www.excelforum.com/showthread...hreadid=390552 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| copying formula | Excel Worksheet Functions | |||
| Copying formula | Excel Discussion (Misc queries) | |||
| Copying Formula | Excel Programming | |||
Threaded Mode
