![]() ![]() When you have an outline with multiple levels, you'll see small numbers for both rows and columns that you can use to the navigate outline structure. ![]() There is no dedicated shortcut for this, but in Windows, you can use the ribbon shortcut, Alt A, GA. ![]() When you have well structured data, with consistent formulas, you can ask Excel to build an outline automatically. To ungroup, use the shortcut Alt Shift left arrow in Windows and Command Shift J on a Mac.Īgain, if you only have cells selected, you'll get a dialog, and you'll need to choose wether you want to ungroup rows or columns.īut when you have entire rows or columns selected, you can ungroup in one step. With entire rows or column selected, you can group in one step. You can speed things up by selecting entire rows or columns before you group. There, you can tell Excel to group either Rows or Columns. If you only have cells selected (not entire rows or columns) this shortcut will cause Excel to display the Group dialog box. The shortcut for grouping rows or columns in Excel is Alt Shift right arrow in Windows and Command Shift K on a Mac. In this worksheet, we have some basic data subtotaled by region and quarter. In this video, we'll look at shortcuts you can use to group, ungroup, and work with outlines. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |