98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Hide separate columns in Excel 2010

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

Added by Yolande on 16th September 2011

More Excel hints and tips, like:

• Remove unused toolbar buttons
• Converting an American date format to European using Formula
• LARGE and SMALL functions and their uses