Excel Group feature allows users to group rows or columns. Ungroup is used to ungroup a range of cells or data that were previously grouped.

Where to use the Group Worksheets feature in Excel? Before I show it to you, know that when you Group Worksheets it will duplicate whatever you write in one sheet into another.

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

Q: I use Excel’s Group tool to expand and collapse our employees’ weekly timesheet data, but it takes forever to group each section individually for each of my 300-plus employees. Can you tell me how ...

In Microsoft Excel, learn how to report time values by the hour using the underlying date serial value.

Working with ranges in Excel is a fast and simple way to identify, define, or refer to a single cell, a range (or group) of cells, a specific or constant value, or a formula. Then you can use ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

Excel documentation refers to variables as "Names," so when you want to create and manage Excel variables, you use the commands in the Defined Name group, such as "Name Manager." ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.