move bar closer together in excel 2016 for mac

#MOVE BAR CLOSER TOGETHER IN EXCEL 2016 FOR MAC HOW TO#

Collapsing & Expanding Columns After Column Grouping The four outline bars you can observe at the top represent different data organisation levels. Once the grouping of the above-mentioned monthly columns is done, you can observe that the columns are grouped perfectly in a dataset. Go to the Data tab in the Home ribbon, and it will open a toolbar below the ribbon, then click on the group option under the outline section now you can observe in a data, the columns are grouped perfectly.Ī similar procedure is applied or followed for the month of Apr, May, Jun & Jul, Aug, Sep & Oct, Nov, Dec columns. Initially, I need to select the column which I want to group it now, let’s select the months (i.e. I don’t want all the monthly sales data to be displayed I want only quarterly & yearly sales data to be displayed it can be done through multiple grouping of column options. Here the data is structured and does not contain any blank cells, hidden rows, or columns. In the below-mentioned example, the Table contains product monthly sales data from Jan to Dec month, and it is also represented in quarterly & yearly sales. Now, you can observe data bars & “+” buttons and “-” buttons disappear in the excel sheet once the ungroup option is selected.Įxample #2 – Multiple Grouping of Columns for Sales Data in Excel On the Data tab, in the Outline group, click on Ungroup command. the columns which you have previously grouped). Select the columns you wish to ungroup (i.e. it is called a state, 1st option is called a hidden state (if you click on it, it will hide B, C, D, E Columns) whereas 2nd option is called unhidden state, it will expand those hidden columns, I.E. You can press the “-” buttons in the margin to collapse the columns (B, C, D, E Columns completely disappears) or in case If you want to expand them again, press the “+” buttons in the margin (B, C, D, E Columns appears)Īnother way to access data is the use of 1 or 2 options on the left side of the worksheet, i.e.

Highlight Active Row/Column in a dataset.How to Collapse & Expand Columns After Column Grouping.

Keyboard and Mouse tricks that will reinvent the way you Excel.Quickly select a far-off cell/range in Excel.You May Also Like the Following Excel Tutorials: Leave the Shift-key (remember to keep the Shift key pressed till the end).Leave the mouse button when you see a bold line to the edge of the column where you want to move this column.Move it to the column where you want this row to be shifted.Select the column (or contiguous columns) that you want to move.The same technique can also be used to move columns in Excel. In the above example, any data outside (above/below or to the right/left of this table) remains unaffected. When you move some cells in a row/column using this method, it will not impact any other data in the worksheet.However, you can move row #5 and 6 at the same time by selecting it.

For example, you can’t move row # 4 and 6 at the same time. You can’t move non-contiguous rows using this method. You can move contiguous rows (or some cells from the contiguous rows).

Here are some important things to know about this method: If you want to move the entire row, you can select the entire row and then follow the same steps. Note that in this example, I have moved the selected cells only.

#MOVE BAR CLOSER TOGETHER IN EXCEL 2016 FOR MAC HOW TO#

Leave the Shift-key (remember to keep the Shift key pressed till the end)īelow is a video that shows how to move a row using this method.

Leave the mouse button when you see a bold line right below the row where you want to move this row.

Move it to the row where you want this row to be shifted.

Click on the edge (with left mouse button) while still holding the shift key.

It would display the move icon (a four directional arrow icon).

Move your cursor to the edge of the selection.

Suppose I have the following dataset and I want to move the highlighted row to the second row (just below the headers): In this tutorial, I will show you a fast way to move rows and columns in Excel – using an amazing shortcut. Now, are you thinking of copying this row, inserting the copied row where you want it, and then deleting it?īut there is a lot faster way to move rows and columns in Excel. Sometimes when working with data in Excel, you may have a need to move rows and columns in the dataset.įor example, in the below dataset, I want to quickly move the highlighted row to the top. Watch Video – The best way to Move Rows / Columns in Excel

Move bar closer together in excel 2016 for mac