Saturday, 2 August 2014

Excel Shortcut Key: How to Hide and Unhide Column and Row in Excel

1.        Select the row you want to hide and press “Ctrl+9”

2.     For Unhide the row select the above and below row and press                                        “Ctrl+Shift+9”

3.        Select the column and press “Ctrl+0” for hide a column

4.        For unhide the column press “Ctrl+Shfit+0”

If the “Ctrl+Shfit+0” not work then do it from mouse

They all work for me except the last one. It fails for Excel 2003, Excel 2007, and Excel 2010.

See Video tutorial…. Please like, share and subscribe


lee woo said...

With integrity, you have nothing to fear, since you have nothing to hide. With integrity, you will do the right thing, so you will have no guilt. See the link below for more info.


Silvia Jacinto said...

Reading your article is such a privilege. It does inspire me, I hope that you can share more positive thoughts. Visit my site too. The link is posted below.

Popular Posts