How to group rows and columns in Excel 2010

Let's learn how to  group rows and cells in Excel to make complex spreadsheets much easier to deal with.

Open an Excel spreadsheet. Let's say I want to group and hide the column C and D so I will only see the Name and the Cost column together.

Select the columns C and D.

Click on column C, hold your mouse and drag it over the column D to select two or more columns.

Click the Data tab in the menu.

And click the Group button.

Both columns are now grouped. Notice the line and the minus (-) sign above the columns you grouped.

Simply click the minus ...

... and the grouped cells are now hidden. To bring them back simply click the + button.