This time around I am going to show how to hide alternate/multiple columns in Excel. Following is a step by step way how can it be done.
To hide alternate columns. For example if you want to hide the columns for example C and E in the excel sheet below, following are the steps:
1. In the column header left click on the first column to be hidden. For example here click on the column header “C” then press and hold down the CTRL key on the keyboard.
2. Continue to hold down the CTRL key and left click on the rest of columns to be hidden. In our example it would be column “E”. It will look like shown below.
3. Right click on one of the selected columns. For our example let say right click on Column “C” and click on Hide.
![clip_image002[1]](http://www.infomatterz.com/blog/wp-content/uploads/2009/05/clip-image00211.jpg "clip_image002[1]")
4. The selected columns and column letters will be hidden from view. In our example Column “C” and “E” would be hidden as shown below.
Related posts:
