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!
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?
Neil_Frieband Yes, these are very much "visual" features. It's unlikely you would have stumbled across them without knowing it. Both buttons, Freeze Panes and Split, can be found together on the View tab of the ribbon. The keyboard shortcuts to access these commands are as follows:
- Alt+W+F+F - Freeze / Unfreeze Panes
- Alt+W+F+R - Freeze Top Row
- Alt+W+F+C - Freeze First Column
- Alt+W+S - Split / Unsplit Panes
There may be other settings that will also cause the described issue with Ctrl+X, but these are the only ones I could confirm so far.