Browse » Home
Sunday, July 17, 2011
How to Create a Border in Excel
1. Open Microsoft Excel.
2. Select the cell or range of cells you want to create a border. For adjacent cells, click the first cell you want to include in the border then drag your mouse until the last cell. This highlights the cells to be included in the border. For nonadjacent cells, click the first cell then press the 'CTRL' key and continue clicking the other cells you want to include. For all cells within the worksheet, click the small box on the corner between the first row (row 1) and the first column (column A.) This selects all the cells.
3. Right-click on the cells included in the border and click 'Format Cells...'
4. Go to the 'Border' tab and under 'Style' choose the border you'd like to use. Choose the color under the 'Color' drop down menu.
5. Click the small boxes around the big box under 'Border.' These small boxes have darkened lines that emphasize the part of the border to be created like the left and right outer borders, upper and lower borders, and the inner borders.
6. Click 'OK' to finish creating the border.