Regarding hiding multiple rows, the rows can be adjacent to each other (for example, hiding rows 2, 3, 4, and 5) or you can hide nonadjacent rows (for example, hiding rows 3, 5, and 7 or 3, 4, 7, and 10). There are several ways to hide row(s) in Excel 2007.
Perform the following to hide row(s):
A. To hide a single row, right click on a row header and from the menu that appears, click Hide.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiL92tQxuws0E0OMLQEPrEklM5_etKrn9vmkemq2dmI2fykYv2mnbgADZpRk7u-rJeaKQ__yLryosSknirDCCOeKLpY6ORyGVrMQ9pSD9ePFUBLrYbTsn7fTXQbdLaAP8_d7Tbz4jPKWiY/s400/Hide+rows+in+Excel+2007.png)
C. For hiding nonadjacent rows, click on the first row header and then press the Ctrl key. Keeping the Ctrl key in pressed state, click to select other rows. Once the selection is over, right click on any selected row header and click Hide.
You can also hide row(s) by clicking on any cell in that particular row and then clicking the Home tab, in the Cells group, click Format, point to Hide and Unhide and click Hide Rows. The keyboard equivalent for this is Alt + H + O + U + R (Alt H O U R).
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7Zl2-ccPtdo8dYZCX_iq0wCwWVj3rei0ryTgXjEuPXA3YYLntlhmUcAw6JBnu5-c4Vy1hzfVKWC9T4TGhqozbyacOd-mEt67v1di1B7MT_UlT_fccXUGdC_RlOFedmFjwi-7bLMTzUKo/s400/Hide+rows+in+Excel+2007+1.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgye-bdGvAE9wgEwn6o66koWhfWwhUCcxVxiIWRvdN0oXKstoplQ6oaQNH_U0RxFtlDlAv99hda4Y_ZQSYUG4Jp8uVNHe5w6H7mv1FgZvtUso6a51qF-w7QfyYwEcOpLlQK9ck6oSA7rXw/s400/Hide+rows+in+Excel+2007+2.png)
0 comments:
Post a Comment