Excel Training Designs Blog

Using Grouping in Excel

By Uncategorized
[vc_row][vc_column][vc_column_text]One of the most simple things you can do in Excel, and will help clean up your workout cards significantly, is to use "Grouping".  This is a feature that allows you to effectively close off cells that are unnecessary to be seen or, more importantly for a coaches perspective, to print.  For example, I use the grouping feature often to close off the "control panel" which allows you select exercise categories as well as program category.  In addition, I use grouping to hide % columns, as they take a lot of space and are unnecessary to print in most cases.  Below I will post pictures on how you can use grouping in your cards.

Here we have a general workout card.[/vc_column_text][vc_single_image image="8772" img_size="medium" alignment="center" style="vc_box_rounded" onclick="link_image"][vc_column_text]The first thing you do is select the column you want to close off, usually this will be a % column.  On both Mac and PC versions, here you will click the Data tab.  On that tab there is a button called "group". Click the"Group" button with your column selected that you wish to close.[/vc_column_text][vc_single_image image="8773" img_size="medium" alignment="center" style="vc_box_rounded" onclick="link_image"][vc_column_text]As you can see, this column now has a line above it, with dots above the selected columns.  The - sign means these columns are open.  You close the column by clicking the - sign, and open it by pressing the +the sign.  You can group many columns and open and close them as you wish!  One caveat, you cannot independently group two columns side by side (excel will group them together).[/vc_column_text][vc_row_inner][vc_column_inner width="1/2"][vc_single_image image="8774" img_size="medium" alignment="center" style="vc_box_rounded" onclick="link_image"][/vc_column_inner][vc_column_inner width="1/2"][vc_single_image image="8775" img_size="medium" alignment="center" style="vc_box_rounded" onclick="link_image"][/vc_column_inner][/vc_row_inner][vc_column_text]This same feature also works for rows as well.[/vc_column_text][vc_row_inner][vc_column_inner width="1/3"][vc_single_image image="8776" img_size="medium" alignment="center" style="vc_box_rounded" onclick="link_image"][/vc_column_inner][vc_column_inner width="1/3"][vc_single_image image="8777" img_size="medium" alignment="center" style="vc_box_rounded" onclick="link_image"][/vc_column_inner][vc_column_inner width="1/3"][vc_single_image image="8778" img_size="medium" alignment="center" style="vc_box_rounded" onclick="link_image"][/vc_column_inner][/vc_row_inner][vc_column_text]Want more tips? View our ETD Membership to learn how to make an advanced strength and conditioning excel template yourself![/vc_column_text][cq_vc_cqbutton buttonlabel="Learn How To Create Your Own Template!" iconbuttoncolor="cqbtn-2" link="url:https%3A%2F%2Fwww.exceltrainingdesigns.com%2Fcreate-a-training-template%2F||"][/vc_column][/vc_row][vc_row][vc_column][/vc_column][/vc_row]