3.1.6.Apply a Border Using the Format Cells Dialog Box |
|
Select a cell or a range.
Click the Home tab.
Click the Borders button arrow and then click More Borders.
|
|
![Click the Home tab. Click the Borders button arrow and then click More Borders.](../../Microsoft-Office-Excel-2007Images/Apply_Border_Using_Format_Cells_Dialog_Box___Click_Home_Tab_Click_Borders_Button.PNG) |
The Format Cells dialog box opens, select the Border tab.
|
|
![The Format Cells dialog box opens, select the Border tab.](../../Microsoft-Office-Excel-2007Images/Apply_Border_Using_Format_Cells_Dialog_Box___The_Format_Cells_Dialog_Box_Opens_S.PNG) |
Select a line style.
Click the Color list and then click a color for the border.
|
|
![Select a line style. Click the Color list arrow and then click a color for the border.](../../Microsoft-Office-Excel-2007Images/Apply_Border_Using_Format_Cells_Dialog_Box___Select_Line_Style_Click_Color_List_.PNG) |
If you want a border on the outside of a cell or range,
click Outline.
If you want a border between cells, click Inside.
If you want to remove a border, click None.
|
|
![If you want a border on the outside of a cell or range, click Outline. If you want a border between cells, click Inside. If you want to remove a border, click None.](../../Microsoft-Office-Excel-2007Images/Apply_Border_Using_Format_Cells_Dialog_Box___If_You_Want_Border_On_Outside_Of_Ce.PNG) |
To set a custom border,
click a Border button or click the Preview Border box.
|
|
![To set a custom border, click a Border button or click the Preview Border box where you want to add a border.](../../Microsoft-Office-Excel-2007Images/Apply_Border_Using_Format_Cells_Dialog_Box___To_Set_Custom_Border_Click_Border_B.PNG) |
Use these buttons to create a diagonal border.
Click OK.
|
|
![Use these buttons to create a diagonal border. Click OK.](../../Microsoft-Office-Excel-2007Images/Apply_Border_Using_Format_Cells_Dialog_Box___Use_These_Buttons_To_Create_Diagona.PNG) |
|
![Use these buttons to create a diagonal border. Click OK.](../../Microsoft-Office-Excel-2007Images/Apply_Border_Using_Format_Cells_Dialog_Box___Result.PNG) |