Forum Discussion
Excel block move
help! excel i have a 300 row spreadsheet and need to move the right hand 2 columns down 1 row. with the active cell as the upper left corner i do a ctrl+shift+ end which selects the the entire block to be moved. i then do ctrl+x to cut the data. most of the time the screen then goes back and displays the pre-cut active cell of the data block. then something happens, which remains permanent for this spreadsheet, the display remains at the bottom of the data block. how can i make the display go back to the start of the block?
13 Replies
Neil_Frieband I was unable to duplicate the described issue (Ctrl+X returns the scroll position to the active cell for me), nor could I find a setting in Excel Options that might explain why this is only occurring in a specific workbook for you. Having said that, Ctrl+Backspace will return the scroll position to the active cell while maintaining the selected range. For example, you might press Ctrl+Shift+End to select the desired range, then Ctrl+Backspace to return the scroll position to the top of the selected range.
Alternatively, for the task of shifting 2 columns, down 1 row, you could simply select 1 row of the target columns (ie: G1:H1), then Right-Click > Insert... > Shift cells down > OK. This can also be accessed on the ribbon by going to Home > Insert > Insert Cells... (or Ctrl+Shift+=). Please note, this method will not work as expected with a structured Excel table.
I hope that helps. Cheers!
- Thanks for your attempts to help. I also could not find any option that would explain this or restore to the original operation. Ctrl-backspace works properly and I guess I just will have to go thru one additional step.
Neil_Frieband By any chance, are you using either Freeze Panes or Split Panes in the problematic worksheet? I just tested this scenario and Ctrl+X does not return the scroll position to the active cell when Freeze/Split Panes are used. That could be the source of your issue...
If you're experiencing issues with Excel's display after cutting a block of data, you can try a few different methods to correct it:
- Use the Keyboard Shortcut: After cutting the data with Ctrl + X, press Ctrl + Home. This keyboard shortcut will return the active cell to the top-left corner of the worksheet.
- Scroll to the Top: If Ctrl + Home doesn't work for you, you can manually scroll back to the top-left corner of the worksheet. You can do this by using the scroll bars on the right and bottom of the Excel window or by using the arrow keys on your keyboard to navigate back to the top-left corner.
- Zoom Out and Zoom In: Sometimes, resetting the zoom level can help correct display issues. You can try zooming out (Ctrl + -) and then zooming back in (Ctrl + +) to reset the display.
- Check Worksheet Settings: Make sure that the worksheet is not frozen or split. If it is, unfreeze or remove the split to return to the normal view.
- Save and Reopen the Workbook: If none of the above solutions work, try saving the workbook, closing Excel completely, and then reopening the workbook. This can sometimes reset display issues.
- Restart Excel: If the problem persists, try closing and reopening Excel. Sometimes, restarting the application can resolve display issues. The text was created with the help of AI.
If none of these methods resolve the issue, it's possible that there may be a more complex problem with the Excel workbook or your system configuration. In that case, you may need to provide more detail informations like you will find in this Microsoft link: Welcome to your Excel discussion space! .
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
- Thanks but the issue is not to return the active cell to the top-left corner of the worksheet but to return the active cell to the top-left corner of the block of data that was cut. The upper-left corner of the block is not in the first column of the worksheet.
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.
