To further organize the many commands available in Microsoft Excel, commands are organized in groups on each tab. Each group contains three or more related commands. The following table lists the groups found on each tab:
- Page Setup
- Scale to Fit
- Sheet Options
- Function Library
- Defined Names
- Formula Auditing
- Get & Transform Data
- Queries & Connections
- Sort & Filter
- Data Tools
- Workbook Views
- Custom Toolbars
The group options may differ slightly if you are using previous versions of Excel. Excel 2016 and 2019 provide some new groups, including Insert > Add-ins and Tours, Data > Get & Transform and Forecast, and Review > Insights ..
In some groups, you will see a button in the lower right corner, next to the group name. This is the Dialog Box Launcher. Opening the group's dialog box will give you access to additional commands associated with that group:
In Excel 2016 and 2019, the Ribbon contains the text "Tell me what you want to do..."
If you click this text, it becomes a text box where you can enter text to search on to quickly perform actions. Just clicking the box pops up some possible ideas.
For example, "Add a comment" brings up a comment in the cell the cursor is in.