Ungrouping worksheets in microsoft excel. To group worksheets hold down ctrl and click the sheet tabs of the sheets you want to group. After you ve finished making changes to multiple worksheets you can ungroup them in two ways. Our workbook contains 3 similar worksheets north mid and south and a blank fourth worksheet.Ĭlick the tab for the first sheet in the group. Let s give it a go open a new excel workbook activate and. From here click select all sheets to group all your worksheets together. Excel for microsoft 365 for mac excel 2019 for mac excel 2016 for mac excel for mac 2011 more. Then hold down shift while you click the tab for the last sheet you want to select. This wikihow teaches you how to group a section of data in excel so that you can hide it from the document.Ĭannot Find Options Tab In Excel For Mac 2016 15 18 Microsoft Community To select two or more non adjacent sheets. Click the tab for the first sheet in the group.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |