Apply a Border Using the Format Cells Dialog Box : Cell Border « Format Style « Microsoft Office Excel 2007 Tutorial






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.
The Format Cells dialog box opens, select the Border tab.
The Format Cells dialog box opens, select the Border tab.
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.
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.
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.
Use these buttons to create a diagonal border. 
           Click OK.
Use these buttons to create a diagonal border. Click OK.
Check the result.
Use these buttons to create a diagonal border. Click OK.








3.1.Cell Border
3.1.1.Apply or Remove a Border Using the RibbonApply or Remove a Border Using the Ribbon
3.1.2.Draw a Border with a colorDraw a Border with a color
3.1.3.Draw a Border with a StyleDraw a Border with a Style
3.1.4.Draw a Border GridDraw a Border Grid
3.1.5.Erase a BorderErase a Border
3.1.6.Apply a Border Using the Format Cells Dialog BoxApply a Border Using the Format Cells Dialog Box
3.1.7.Switch between Draw Border and Draw Border GridSwitch between Draw Border and Draw Border Grid
3.1.8.Place a border around the entire worksheetPlace a border around the entire worksheet