It depends on the number of horizontal or vertical cells in the moved area, if you move to a different sheet. 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. You see only the upper border when target cells will be shifted down. In insert mode you see only the left border when target cells will be shifted to the right. In overwrite mode you see all four borders around the selected area. The surrounding box of the moved cells looks different in insert mode. In insert mode, the existing cells where you drop will be shifted to the right or to the bottom, and the dropped cells are inserted into the now empty positions without overwriting. When you hold down the Option Alt key while releasing the mouse button, you enter the insert mode. Note that to drag-and-drop entire rows or columns, you must select the rows or columns you want to move (or copy) first, then start dragging from selected cells, not from the row or column headers (cells would be deselected by this). When you drag-and-drop a selection of cells, rows or columns on a Calc sheet, the cells (including the ones in selected rows or columns) normally overwrite the existing cells in the area where you drop.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |