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

Home
Microsoft Office Excel 2007 Tutorial
1.Introduction
2.Editing
3.Format Style
4.Table
5.Chart
6.Formula
7.Workbook Worksheet
8.Wordart Clip Art Shape Picture
9.PivotTable PivotChart
10.Data Analysis
11.Macro ActiveX Add in
12.Security
13.Collaboration
14.Database functions
15.Date Time functions
16.Engineering functions
17.Information functions
18.Logical functions
19.Lookup Reference functions
20.Math Trigonometry functions
21.Statistical functions
22.Text functions
VBA / Excel / Access / Word
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Microsoft Office Excel 2007 Tutorial » Format Style » Cell Border 
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.
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
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.