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 ...
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?
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.
- Thanks for your continuing research. You are right that is is highly unlikely that I accidentally hit any Alt+W combination.