Whether the target area will be shifted to the right or to the bottom depends on the distance between source and target cells, if you move within the same sheet. It depends on the number of horizontal or vertical cells in the moved area, if you move to a different sheet.
如果您在同一工作表中移动，目标区域是否移到右侧或底部取决于源单元格和目标单元格的间隔。如果您移到不同的工作表，则取决于移动区域内的水平或垂直单元格数目。