Forum Discussion
Excel block move
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...
- I'm glad you were able to reproduce the problem. At least now you can see what my specific problem is. Is there anything visual to indicate that the worksheet has Freeze Panes or Split Panes? Is there a key combination that I might have hit by accident which will cause the worksheet to have Freeze Panes or Split Panes?
