How to Add Cell Borders and Background Colors in Excel
Adding cell borders and filling cells with colors and patterns is an easy way to make your data stand out, appear more organized, and make the spreadsheet easier to read.
A list of borders you can add to the selected cell(s) appears. Use the examples shown next to each border option to decide which border type will work best for you.
To remove a border, click the Border list arrow in the Font group and select No Border.
To have more control over the look and style of the cell borders, use the advanced border options.
You now need to specify where you want the new border style to appear.
The border is applied to the cell range.
A palate of theme colors is displayed in the menu. If you want to use a different color, select More Colors.
A background color is applied to the cell(s). Make sure the background provides enough contrast with the text to be legible.
Free to distribute with our compliments; we hope you will consider our paid training.