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 |