Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Disabling Drag And Drop Referencing
I have a list of products to be made. On the next column I have a Lookup
function that brings up descriptions and info based on that list. I usually need that base list to be reorganized. Unfortunately, I can't just drag them into the order I need b/c the lookup function tracks where the cell went and now the descriptions do not match next to their product. Is there a way to disable this, or is copy.paste.erase old. the only way to go? Chris Cameron |
#2
|
|||
|
|||
Without a better description of what you have including formulas
and where table is if not readily apparent from your formulas it would be difficult to know what the problem is. You can move an entire row(s) between two other rows by selecting the contiguous rows to be moved, and then holding the shift key while dragging the upper or lower border of the selection of cells to be moved. http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "camerons" wrote in message ... I have a list of products to be made. On the next column I have a Lookup function that brings up descriptions and info based on that list. I usually need that base list to be reorganized. Unfortunately, I can't just drag them into the order I need b/c the lookup function tracks where the cell went and now the descriptions do not match next to their product. Is there a way to disable this, or is copy.paste.erase old. the only way to go? Chris Cameron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help please simple drop and drag I can't make work | Excel Worksheet Functions | |||
cell drop and drag | Excel Worksheet Functions | |||
drag and drop to get a lot of wordarts? | Excel Discussion (Misc queries) | |||
drag and drop to get a lot of wordarts? | Excel Discussion (Misc queries) |