Regarding hiding multiple columns, the columns can be adjacent to each other (for example, hiding columns C, D, E, and F) or you can hide nonadjacent columns (for example, hiding columns D, H, and K or D, E, H, and K). There are several ways to hide column(s) in Excel 2007.
Perform the following to hide column(s):
A. Right click on a column header and from the menu that appears, click Hide.
B. For hiding multiple columns that are adjacent to each other, click the first column header and then press the Shift key. Keeping the Shift key in pressed state, click to select the last column header and then right click on any selected column header and from the menu that appears, click Hide.
C. For hiding nonadjacent columns, click on the first column header and then press the Ctrl key. Keeping the Ctrl key in pressed state, click to select other columns. Once the selection is over, right click on any selected column header and click Hide.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPS_AhyphenhyphenutLPdkP_l4yWqdOEYznOw2DmEgkSYq-75dTRzJNLQL5uuZF8TLu7rdvyEOPRVbs0OrjjiGVUsCMxEUBnu_wosXY1xFYqBpLFg_5Mjt6_mFyFsVzaFrIaZHckxcRNTDPgnGLPrI/s400/Hide+Columns+in+Exce+2007.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD98k6hNxyoxMPLOXUdO-GFEkq7ApxW57dx4OTVBcScEdZu3EOgv7U14X6N_1LdOp_Bbc_1_UNxmrC2zyClKMyIX_WwgG2A7fL8e0gVtr4vhlb_b4AoRsP7OUFEWaTAWKWFc4RPCPEhyphenhyphenM/s400/Hide+Columns+in+Exce+2007+2.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUVV0JkKcQU77RqcEmK5IfRA-8HeX88NhGnMMVA_6kV18InBnhWOdwpQnC08DTzYH7v-yWmgCPjU9h8Q8buTe1gwd2pjlbapDca9ppuQZENUqzxSNmV8tb8DGxor5eCvXO_QlzL1I7taA/s400/Hide+Columns+in+Exce+2007+3.png)
0 comments:
Post a Comment