Page 186 - CA 165 ver 1.0 Class 9
P. 186

Hiding Columns

                  In a worksheet, if the user does not want to show columns or rows that contain some part of data on the
                  screen, it can be hidden with the help of ‘Hide’ feature. Individual cell can’t be hidden in the spreadsheet.

                  To hide a column:
                  Step 1:   Select the column to be hidden.
                  Step 2:   Right click on the column header.
                  Step 3:   Select the option ‘Hide’.



                                                                                          2
                                                                                                  3

















                                                                                              The selected
                                                                                         column is hidden which
                                                                                          is denoted by blue line
                                                                                          in the column header.

                         1


                  To unhide the hidden column:
                  Step 1:     Select the column present on both sides of the hidden column and then right click on column header.
                  Step 2:   Click on the ‘Show’ option.






















                                        2






                  Similarly, we can hide rows from the worksheet.


                   184    Touchpad Computer Applications-IX
   181   182   183   184   185   186   187   188   189   190   191