Forum Discussion
Excel block move
If you need to return the active cell to the top-left corner of the block of data that was cut, rather than the top-left corner of the worksheet, you can follow these steps:
After cutting the data with Ctrl + X, press Ctrl + Home to return to the top-left corner of the worksheet.
Navigate to the top-left corner of the block of data that was cut using the arrow keys on your keyboard or by scrolling if necessary.
Once the active cell is positioned at the top-left corner of the block of data, you can proceed with pasting the data or performing any other actions needed.
This way, you'll ensure that the active cell is returned to the top-left corner of the specific block of data that was cut, rather than the top-left corner of the entire worksheet.
- The real issue is that for a while after cutting with Ctrl-X the the active cell at the left hand corner of the block of data is automatically restored and displayed. Then something happens and the system no longer returns to the active cell but remains displaying the the lowest row of the selected block. At this point this new operation is permanently associated with this workbook. What caused this change and can the original operation be restored? is there a way to send you copies showing you both operations?