![]() Step 2: When you clicked on the minus sign, a column will collapse, and it results in the hide in a column.Step 1: Click on the minus sign, which was created while grouping the column.Now you will be able to see the two minus signs it means that there are two groups created in a particular spreadsheet that you want to group. Step 3: Go to the option group and make the group of a column as selected.read more and select the group option in the outline toolbar, as shown in the below screenshot. Users can, however, customize it to their liking and add any option or button to make it easier to access the commands. Step 2: Go to the data option in the excel toolbar Excel Toolbar The toolbar, also known as the quick access toolbar, is located on the left top-most side of the excel window and has only a few options by default, such as save, redo, and undo.This is the result when you want to hide the column C and D in a spreadsheet, and it automatically enables the grouping option in your spreadsheet. As shown below in the screenshot, you will able to see the minus sign symbol added to the outline above the selected columns. When you click on the group, it will enable you to group the particular column in your excel spreadsheet. ![]() ![]() Go to the data option in the excel toolbar and select the group option in the outline toolbar, as shown in the below screenshot.Select the data that you are using to group the column in excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |