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...