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
   44   45   46   47   48   49   50   51   52   53   54