how to sort data by color in excel for mac 2016

Sort Data By Color In Excel 2016 How To Change A

If you have a lot of worksheets in your workbook, it may be hard to quickly find a particular sheet.

Sort Data By Color In Excel 2016 How To Change A

Well show you how to change a single worksheet tab or multiple worksheet tabs at once.

Click on a color to select it, or click on More Colors if you want a color you dont see on the palette.

Make sure the worksheet tab for which you want to change the color is the active tab.

Click Format in the Cells section, move your mouse over Tab Color, and then click a color on the colors submenu.

Once you press T, youll see the colors submenu where you can click on a color to choose it, or you can use the arrow keys to move to the color you want and then press Enter.

To change the color of two or more contiguous worksheet tabs, click the first tab you want to select and then press Shift and click on the last tab you want to select.

Then, right-click on any of the tabs in the selected group and change the Tab Color as shown earlier.

If all the tabs are selected, you can right-click on the tabs and select Ungroup Sheets from the popup menu.

Again, while the tabs are still selected, they are colored in a light gradient shade of the chosen color.

Shes been a senior technical writer, worked as a programmer, and has even run her own multi-location business.

Since we launched in 2006, our articles have been read more than 1 billion times.

How To Sort Data By Color In Excel For Mac 2016