Page 74 - PlusGPT_V2.1_C7_Flipbook
P. 74

On the other hand the Redo command is used to reverse the last Undo command or action. You can
                  access both the commands from the Quick Access Toolbar located at the top-left corner of the Excel
                  2016 window. You can also use the Ctrl + Z key and Ctrl + Y key to Undo and Redo respectively.


                       Column Width and Row Height
                  On a worksheet, you can specify a column width of 0 to 255 and a row height of 0 to 409. This value
                  represents the number of characters that can be displayed in a cell that is formatted with the standard
                  font. The default column width is 8.43 characters and the default row height is 15 points. If a column/
                  row has a width or height 0, it is hidden, i.e., it is not visible in the grid.


                  Set Column Width/Row Height
                  To set column width or row height, follow the given steps:

                  Step 1:  Select the column(s) or row(s) whose width or height you want to change.
                  Step 2:  Click on Format command in Cells group from Home tab.

                  Step 3:   Choose Column Width or Row Height under
                           Cell Size section from the drop-down list.
                             A Column width or Row height dialog box
                           will appear.

                  Step 4:   In  the  Column  Width  or  Row Height  box,
                           type the value that you want your column or
                           row to be.                                                   Setting column width
                  Step 5:  Click on OK button to get new row height / column width.











                                            Row Height dialog box      Column Width dialog box
                                                                                                Select All button
                  Automatically Fit Column/Row Content

                  To set column width or row height automatically, click on the Select All
                  button. Double-click any boundary between two column/row headings. All
                  columns/rows in the entire worksheet will be changed to the new size.         Selecting entire worksheet


                                                              Tech Fact
                          At times, a cell might display #####. This can occur when the cell contains a number
                           or a date that exceeds the width of the cell so it cannot display all the characters
                         that its format requires. To see the entire contents of  the cell with its current format,
                                              you must increase the width of the column.





                  72    Premium Edition-VII
   69   70   71   72   73   74   75   76   77   78   79