Page 64 - iPro_trackGPT_V5_Class7
P. 64

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 command. To move data, click
                        on Cut command. To copy cells, click on Copy command.



                                                                           4  Click on the
                                                                          Paste command.












                      1  Select the cells that you want to move or copy.


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


                          Tech Tweak
                    Similar to Word, Excel also allows us to use 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


                     USING UNDO AND REDO FEATURES

                  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.

                     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. The default column width is 8.43 characters, and

                  the default row height is 15 points. If a column or row is set to a width or height of 0, it becomes
                  hidden and will not be visible in the worksheet grid.





                    62    TrackGPT iPRO (V5.0)-VII
   59   60   61   62   63   64   65   66   67   68   69