How to Use Borders in Microsoft Excel

Instant Borders
1. Launch Microsoft Excel and create or open a workbook with some information entered into some cells.
2. Click in a cell that contains information to highlight the cell.
3. Click the 'Home' tab on the tool bar.
4. Click the small pull down arrow to the right of the 'Border' button in the 'Font' group.
5. Click on the desired border style to instantly apply the selected border to the currently highlighted cell. Alternately click on 'No Border' to remove the existing border from the cell, or click on one of the more advanced alternatives from the 'Draw Borders' section of the pull down menu.
Format Cell Borders
6. Click on a single cell to select that cell, or click on a cell and hold the left mouse button down while dragging the mouse across a range of cells and then release the mouse button to select the entire range of cells that is highlighted.
7. Click the small symbol in the lower right corner of the 'Fonts' menu on the 'Home' tab. Alternately right-click on any one of the selected cells and click 'Format Cells' or hold down 'CTRL' and 'Shift,' then press the letter 'F' once and release all keys. This will bring up the 'Cell Properties' dialog box. Click the 'Border' tab.
8. Click on the desired line style for the border. Click on the color pull down box and select a color.
9. Click on the various border buttons along the outside of the preview pane to show what the border would look like if chosen. Click the same button again to toggle the border item off. Click 'OK' to save the settings and apply the border to the work book.