On the Data tab, click the Outline button on the right corner of the Excel interface. Click Group. In the Group menu, click Group. A Group dialog box will open, displaying the options Columns or Rows.

If your data is grouped in Microsoft Excel, try displaying a border between groups. Learn how to make your Excel tables easier to read.

In Microsoft Excel, you can permanently hide columns containing data you don't need to have on show. However, grouping columns is often a better way to achieve the same outcome, especially if you ...

Getting the data into Power Query requires following just a few steps. 1. Click anywhere inside the Excel Table. 2. Click the Data tab. 3. In the Get & Transform Data group, click From Table/Range.

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, data summaries created via PIVOTBY automatically update to reflect ...

If you have Excel 2010, you can use the new Slicers tool to make your PivotTable even easier to work with. Slicers let you select the data to show in the PivotTable in a more visual way.

This tutorial shows the steps to use Automatic Data Type in Microsoft Excel. It allows you to insert details of cities, food items, music, animals, persons, etc, automatically.