COMPUTER TIPS

Home | Previous Page| About Us | Set As Home Page

 

Google

  Google Groups Beta Subscribe to Computer free Tips                                                  

Email:

May, 29 , 07                    Today's Tip                                 Add to Favorites    Tell A Friend

                                                                              

How to manage the borders to Cells in Excel?

A border is a line drawn on any side of cell, around a cell or around a group of cells. You can add lines to the edges of the selected cell or selected multiple cells. The Borders command does not draw a line under the contents of the cell, but it draws lines on the borders of cell. 

To draw line around the selected cells, follow these steps. 

  • Select cell or range of cells.
  • Click downward arrow next to the” Borders” icon on the Formatting Toolbar and select the required option.
  • Click” Border” tab of dialog box and select border options and the line style to draw border (if required)
  • Click “OK” button of dialog box.

Changing Border Line Style

You can also change the line style of the border or borders of different line styles can be drawn on each side of the cells. To draw line of different styles around the cell, follow these steps.

  • Select cell or group of cells.
  • Open “Format Cells” dialog box and click border tab.
  • Select the color of line (if required) by clicking Color dropdown list box.
  • Select line style and click the border option from dialog box.
  • Click ”OK” button of dialog box

Removing Borders around the cells

You can very easily remove the borders drawn around the cells. To remove the borders, follow these steps.

  • Select the cell or group of which you want to remove borderlines.
  • Click the arrow next to Borders icon on the Formatting Toolbar and select first option.

 

 

 

 

 

 

 

 

       

 

            

 

 

 

 

 

 

 

 

 

 

    

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


 

 

 

 

 

 

 

 

 

 

 

 


 

 

 

 

 







 

 

 

 

 

 

 

 

 

   












 

 




 











 

 

 




 

 

 

Previous Tips e

28-05-07
27-05-07
26-05-07
25-05-07
24-05-07
23-05-07
22-05-07
21-05-07
20-05-07
19-05-07
18-05-07
17-05-07
16-05-07
15-05-07
14-05-07
13-05-07
12-05-07
11-05-07
10-05-07
09-05-07
08-05-07
07-05-07
06-05-07
05-05-07
04-05-07
03-05-07
02-05-07
01-05-07
30-04-07
29-04-07
28-04-07
27-04-07
26-04-07
25-04-07
24-04-07
23-04-07
22-04-07
21-04-07
20-04-07
19-04-07
18-04-07
17-04-07
16-04-07
15-04-07
14-04-07
13-04-07
12-04-07
11-04-07
10-04-07
09-04-07
08-04-07
07-04-07
06-04-07
05-04-07
04-04-07
03-04-07
02-04-07
01-04-07
30-03-07
29-03-07
28-03-07
27-03-07
26-03-07
25-03-07
24-03-07
23-03-07
22-03-07
21-03-07
20-03-07
19-03-07
18-03-07
17-03-07
16-03-07
15-03-07
14-03-07
13-03-07
12-03-07
11-03-07
10-03-07
09-03-07
08-03-07
07-03-07
06-03-07
05-03-07
04-03-07
03-03-07
02-03-07
01-03-07
28-02-07
27-02-07
26-02-07
25-02-07
24-02-07
23-02-07
22-02-07
21-02-07
20-02-07
19-02-07
18-02-07
17-02-07
16-02-07
15-02-07
14-02-07
13-02-07
12-02-07
11-02-07
10-02-07
09-02-07
08-02-07
07-02-07
06-02-07
05-02-07
04-02-07
03-02-07
02-02-07
01-02-07
30-01-07
29-01-07
28-01-07
27-01-07
26-01-07
25-01-07
24-01-07
23-01-07
22-01-07
21-01-07
20-01-07
19-01-07
18-01-07
17-01-07
16-01-07
15-01-07
14-01-07
13-01-07
12-01-07
11-01-07
10-01-07
09-01-07
08-01-07
07-01-07
06-01-07
05-01-07
04-01-07
03-01-07
02-01-07
01-01-07