Microsoft Excel 2007 tutorial: apply or remove cell borders


Apply or remove cell borders

X. Apply or remove cell borders

When you open Microsoft Office Excel, you see the worksheets are tables that consist of rows and columns. In fact, those worksheets are not the tables. They are divided into rows and columns by the gridlines. If you print the worksheet, you will see the worksheet is blank (no rows and columns) or if you print preview data that you entered on the worksheet, you will see the data are on the blank worksheet too. However, you can apply borders to a cell or range of cells on a worksheet. You can also format cell borders with different colors and line styles. Whenever you don't need the cell borders, you can remove them immediately.

X.1. Apply cell borders

Excel provides predefined border styles that you can quickly apply a border around cells.

- Select the cell or range of cells that you want to add a border.

- On the Home tab, in the Font group, click drop-down arrow next to Border.

Excel 2007 arrow border

- Click any border style you want to use.

Excel 2007 apply cell border

Note: To apply the most recently used border to cells, click Border button Excel 2007 Border button (not the arrow).

X.2. Change color and line style of cell borders

The predefined border styles are solid lines with black color. But, you can change the color and line style that you want for cell borders. To format a cell border, do the following:

- On the Home tab, in the Font group, click drop-down arrow next to Border, and then click More Borders.

Excel 2007 More Borders

- In the Format Cells dialog box, on the Border tab, in the Style and Color boxes, select the line style and color that you want.

Excel 2007 Line Style and Color boxes

Note: If you need the colors other than the colors in the Color box, click More Colors.

To apply the border line style with color that you selected to the cells, click the presets, preview diagram or the buttons (under Border). You can apply outline, inside, top and bottom borders or other border options that you want.

Excel 2007 presets preivew diagram and buttons

X.3. Remove cell borders

- Select the cell or range of cells that you want to take off the borders.

- On the Home tab, in the Font group, click drop-down arrow next to Border, and then click No Border Excel 2007 No Border.

Or

- If you are using the Format Cells dialog box, on the Border tab, click None under Presets.

 


Comments

Michael Leng comment

 Michael Leng

Great guide,

Thanks.


2013-10-31




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.