I have tried dragging into another workbook. This works. All references from the original workbook is preserved. Thus, this means Excel does support moving everything, keeping the entire format, and keeping the original formulas for each cell. However, I have not found how to drag into another sheet.