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.
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.
- Click any border style you want to use.
Note: To apply the most recently used border to cells, click Border button (not the arrow).
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.
- 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.
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.
- 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 .
- If you are using the Format Cells dialog box, on the Border tab, click None under Presets.
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: