Tuesday, February 11, 2014

How to make different types of cell Border

How to make different types of cell Border: 


1. Select the cell range
2. On the Home tab, in the Alignment group, click the Format Cells dialog box launcher
next to Border, and then select the style that you want in the Border list.


3. Click OK 

Details the Format Cells dialog box: 
Line:
Select an option under Style to specify the line size and style for a border. If you want to change a line style on a border that already exists, select the line style option that you want, and then click the area of the border in the Border model where you want the new line style to appear.

Presets: 
Select a predefined border option to apply borders to or remove borders from selected cells.

Color: 
Select a color from the list to change the color of the selected cells.

Border:
Click a line style in the Style box, and then click the buttons under Presets or Border to apply borders to the selected cells. To remove all borders, click the None button. You can also click areas in the text box to add or remove borders.
Post a Comment