Formatting Borders in Microsoft Excel


My very good friend, AJ, requested I post this particular article. After using Excel for many years, I suppose some of us take some things for granted, but formatting borders can be tricky if you don't know a couple of the tricks.

Select the cells you want to format with borders. Go to Format Cells and choose the Borders tab.

Now, before you do anything else, choose the line Style, and the line Color. Then, watching the preview window (that's the window with the word "text" in there), choose the different buttons to the left and bottom to see how they work. To apply this border to all the cells, just hit the Inside and Outline buttons.

Thanks for the inspiration, AJ!