Page 45 - Touchpad_Plus_V3.2_Class 6
P. 45

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.
                          OR

                          Click on the Edit → Copy to copy the contents of the selected cells.

                 Step 3  Click on the cell where you would like to paste.

                 Step 4  Click on the Edit → Paste to paste.













                                 Cut                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 inch to 39.37 inch and a row height of
                 0 inch to 39.37 inch. 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       43
   40   41   42   43   44   45   46   47   48   49   50