![change the border color in excel for mac change the border color in excel for mac](https://www.customguide.com/images/lessons/excel-2019/excel-2019--borders-and-background-colors--04.png)
#Change the border color in excel for mac mac
Use control + 1 on Windows, command + 1 on a Mac to open Format Cells, then control tab to Borders. You can also apply borders with the Alt key, but only in the Borders tab of the Format cells dialog. Again, you don't have control over line thickness and color. On Windows, you can do something similar with Ribbon shortcuts, using Alt H, BA to apply all borders.
![change the border color in excel for mac change the border color in excel for mac](https://cdn.extendoffice.com/images/stories/doc-excel/change-boder-color-of-active-cell/doc-change-border-color-1.png)
I don't think this is very useful myself, because you can't control the line width or color. The Mac version lets you toggle borders on the right, left, top, and bottom using Command + Option + with the respective arrow keys. On a Mac, there are a number of dedicated shortcuts for borders. This removes all borders but it doesn't affect any content or other formatting.Īlso, Paste special has an option to copy cells without borders, which can be useful when you're coping data with borders.įinally, you can use clear formats to remove borders, but keep in mind that you'll also loose other formatting as well. So, first off, you can remove all borders with Control + Shift + _ in Windows, Command + Option + _ on a Mac. On a mac, tick the setting on the Layout tab of the ribbon. In Windows, you can turn gridlines on and off with Alt W + VG When you working with borders in Excel, you may want to turn off gridlines so you can more easily see what you're doing.
![change the border color in excel for mac change the border color in excel for mac](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2012/07/change-cell-border-color-excel-2010-4.jpg)
And you can pop right back up to the filter button and choose a different color in the pop-out menu to quickly see those counts too.In this video, we'll look at shortcuts to apply and remove borders. When you look at your subtotal cell, you should see the count change to only those cells for the color you selected. Note: If you use font color instead of or in addition to cell color, those options will display in the pop-out menu. Click the one for the column of colored cells you want to count and move your cursor to “Filter by Color.” You’ll see the colors you’re using in a pop-out menu, so click the color you want to count. This places a filter button (arrow) next to each column header. Click “Sort & Filter” and choose “Filter.” Select your column header and go to the Home tab. Now it’s time to apply the filter feature to your cells. Note: For other function numbers you can use with SUBTOTAL, take a look at the table on Microsoft’s support page for the function.Īs a quick check to make sure you entered the function correctly, you should see a count of all cells with data as the result. The number 102 in the formula is the numerical indicator for the COUNT function. Enter the following, replacing the A2:A19 references with those for your own range of cells, and hit Enter. Go to the cell where you want to display your count. Let’s start by adding the function, which is SUBTOTAL. You’ll use a combination of a function and a filter. If you plan to adjust the data over time and want to keep a cell dedicated to your colored cell count, this second method is for you. You can also review the exact cells in the bottom portion of the window, just above the cell count. When the window expands to display your results, you’ll see the count on the bottom left as “X Cell(s) Found.” And there’s your count! If it looks correct, click “Find All” at the bottom of the window. Using either of the above two ways to enter the format you’re looking for, you should next check out your preview. This will put the formatting for that cell into the preview. When your cursor transforms to an eyedropper, move it to one of the cells you want to count and click. Click the arrow next to the Format button and select “Choose Format From Cell.”
![change the border color in excel for mac change the border color in excel for mac](https://i0.wp.com/www.tenforums.com/attachments/tutorials/51251d1448910936-inactive-title-bar-color-change-windows-10-a-titlebars.jpg)
Unknown formatting: If you’re not sure of the exact color or used multiple format forms like a fill color, border, and font color, you can take a different route.