How to Change Border Color in Excel 2010


Microsoft Excel 2010 is an almost infinitely customizeable program. Aside from being able to choose, edit and modify every cell in your spreadsheet, you can also set options for how the cells are displayed. This does not apply to only the data in the cells, however. You can also customize the way that the cells themselves look. This includes providing you with means to learn how to change border colors in Excel 2010. If, for example, you wanted to print or display your cells with a border color other than black, Excel 2010 allows you to do so. The method for changing border colors in Excel 2010 is found on the Format Cells menu, and gives you multiple options for choosing how to color your cell borders.

 

Color Cell Borders in Excel 2010

 

If you elect to combine cell border colors with cell fill colors, you will probably be able to come up with some pretty interesting effects. Aside from simply improving the appearance of your spreadsheet, this can also be a helpful way to sort and organize your information. Regardless of your intentions, you can easily learn how to change the border colors of cells in Excel 2010 using the steps outlined below.

 

Step 1: Open the spreadsheet containing the cells for which you want to change the border color.

Step 2: Use your mouse to select the cells whose border colors you want to change. You can also click the cell at the top-left corner of the spreadsheet between the row 1 and column A headings to select all of the cells in the worksheet.

select your cells

 

Step 3: Right-click the highlighted cells, then choose the Format Cells option.

format highlighted cells

 

Step 4: Click the Border tab at the top of the window to display the cell border customization menu.

choose excel 2010 cell border color

 

Step 5: Click the drop-down menu under Color, then choose the color that you want to use for your cell borders. You can also select a line style from the window at the left side of the window.

how to change border color in excel 2010

 

Step 6: Choose the border styles you want to use under Presets at the top of the window. If you want to highlight the borders of each individual cell, choose both the Outline and Inside option.

 

Once all of your border color settings have been established, click the OK button at the bottom of the window to apply the changes.

It is important to follow the steps in this order to set your border colors, otherwise Excel 2010 will continue to apply a black border to the cells.

how to start your own website
Have you ever wanted your own blog or website? Click here to learn how to get started today and have you own domain in less than 20 minutes!