Page 71 - TP_iPlus_V2.1_Class7
P. 71

Cut, Copy, and Paste Data

                 We can use the Cut, Copy, and Paste commands in Excel to move or copy entire cell content. The
                 Cut command moves the content to a new location, removing it from its original location.
                 With the Copy command, content is copied to the new place and also exists in its original place.
                 The Paste command is used to paste the copied/cut data.

                 When you move or copy a cell, Excel moves or copies the entire cell contents with cell formatting.
                 To do so, follow the given steps:

                    2  Click on the Cut/Copy option in the
                   Clipboard group under the Home tab.
                   To move, click on the Cut option. To            4  Click on the Paste option on the
                   copy, click on the Copy option.                 Clipboard group under the Home tab.
















                        1  Select the cells that you want to move       3  Click on the cell where you would like to
                       or copy.                                        paste the copied data.

                    Quick Byte


                     Similar to Word, Excel allows the use of shortcut keys to copy, cut, and paste the content
                     of the cells. The shortcut keys are:
                     •  To Copy: Ctrl + C
                     •  To Cut: Ctrl + X
                     •  To Paste: Ctrl + V



                  i +  USING UNDO AND REDO FEATURES

                 Similar to Word, Excel also allows you to use the Undo and Redo commands. The Undo command
                 reverses the most recent action you performed in the worksheet and can undo multiple actions
                 sequentially. Conversely, the Redo command reverses the last action that was undone. Both
                 commands can be accessed from the Quick Access Toolbar located at the top-left corner of the
                 Excel window. You can also use the Ctrl + Z key and the Ctrl + Y key to Undo and Redo respectively.

                  i +  COLUMN WIDTH AND ROW HEIGHT

                 In a worksheet, you can set a column width ranging from 0 to 255 characters and a row height

                 from  0  to  409.5 points.  The  column width  represents the  number  of  characters  that  can  be
                 displayed in a cell using the default font size.




                                                                                                                  69
                                                                                          More on Spreadsheets
   66   67   68   69   70   71   72   73   74   75   76