/text/shared/01/02060000.xhp Sun Microsystems, Inc.

pasting; cell ranges clipboard; pasting cells; pasting pasting; Enter key pasting; Ctrl+V shortcut mw deleted "cell ranges,pasting" overwrite dialog in Calc if target is not empty Paste Inserts the contents of the clipboard at the location of the cursor, and replaces any selected text or objects.UFI: text used for icon and menu

Press the Enter key.

In a spreadsheet, when you paste a range of cells from the clipboard, the result depends on the current selection: If only one cell is selected, the cell range will be pasted started from that cell. If you mark a cell range wider than the cell range in the clipboard, the cell range will be pasted repeatedly to fill the selected cell range. Pasting contents in %PRODUCTNAME Calc When copying a cell or a range in %PRODUCTNAME Calc the selection is marked with blinking dashes around the range (the "marching ants") to indicate what was being selected during the clipboard operation. Marching ants mark for Calc clipboard There are two ways to paste the clipboard contents in a spreadsheet document: Using CommandCtrl+V shortcut, the Paste icon in the toolbar or choose Edit - Paste: The contents of the clipboard is pasted in the target location and the clipboard keeps the contents for more paste operations. The copied selection mark stays active. Using Enter key: the clipboard contents is pasted once and cleared. No further paste is possible with the clipboard contents. The copied selection mark is disabled. To deactivate the copied selection mark press the Esc key. The clipboard contents is not cleared.