Page 49 - TechPluse_C6_Flipbook
P. 49
MODIFYING DATA
Just like in LibreOffice Writer, data can be modified in LibreOffice Calc also.
Cut, Copy, and Paste Data
You can use the Cut, Copy, and Paste commands in LibreOffice Calc to move or copy entire cell
or their contents.
Tech
Funda
Calc displays an animated moving border around cells that have been cut or
copied. To cancel a moving border, press Esc key.
Move/Copy Cells
When you move or copy a cell, Calc moves or copies the entire cell, contents and cell formats.
Perform the below steps to move/copy cells:
Step 1 Select the cells that you want to move or copy.
Step 2 Click on the Edit → Cut option to move the contents of the selected cells.
Step 3 Click on the Edit → Copy to copy the contents of the selected cells.
Step 4 Click on the cell where you would like to paste.
Step 5 Click on the Edit → Paste to paste.
Copying contents of a Cell Pasting contents of a cell
Clickipedia
Calc replaces existing data in the paste area when you cut and paste cells to move them.
COLUMN WIDTH AND ROW HEIGHT
In a Calc worksheet, you can specify a column width of 0 cm to 100 cm and a row height of 0 cm
to 100 cm. This value represents the number of characters that can be displayed in a cell that is
formatted with the standard font.
More on LibreOffice Calc 47

