Step by step exercise. Cell border format.


Objective.

 

Differentiate between and use the different options availible in Excel2003 to change borders.

 

Step by step exercise.

 

1 If Excel2003 is not open, open it in order to perform the exercise.

2 Open the Initial Fruit sales workbook found in the Exercises folder of the course.

3 Select the range A4:H12 .

4 Go to Formats.

5 Select the Cells... option.

6 Click on the Border option.

7 Click on the Outline option in the Presets box to put a border around the selection.

Observe how a box with a thin line appears in the bottom box. We are going to change this type of line.

8 Click on the thick line option in the Style box.

9 Click on the Outline button in the Presets box.

Observe the bottom box.

10 Click on the arrow to the right of the Color box to open the list of availible colours.

11 Select the colour Red.

12 Click again on the Outline button in the Presets box.

13 Click on OK.

Observe the result, to see better click on any cell in such a way that the previous selection is removed.

14 Select the range A5:A12 .

15 Go to Formats.

16 Select the Cells... option.

17 Click on the Border option if it is not already activated.

Observe how in the bottom box it is indicated that the top and left part of the selection there is a thick red line (the one we made before). We will now put a thin red line in the top and right part.

18 Select Fine line from the Style box.

19 Select blue from the Color box.

Now we only need to indicate where to put the line.

20 The model will be displayed in the Border box, observe how there are a few buttons connected to each border, clic on the top and right border.

Observe the result.

21 Click on OK.

We are going to perform a similar operation on the range B4:H4 .

22 Select the range B4:H4.

23 Go to the Format menu.

24 Select the Cells... option.

25 Click on the Border option if it is not already activated.

Observe how in the bottom box we are indicated that in the top and right part of the selection there is a thick red line (that which we made before). We will now put a thin blue line in the lower, left, and midddle vertical part to seperate each cell.

 

26 Select the Fine line from the style box.

27 Select Blue from the Color box.

Now we only need to show where to put the line.

28 Click on the bottom, left, and middle vertical border in the Border box.

Observe the result.

29 Clic on OK.

We will now place a thin blue line to seperate each cell in the range B5:L12.

30 Select the range B5:H12 .

31 Go to the Format menu.

32 Select the Cells... option.

33 Click on the Border option if it is not already activated.

34 As the thin blue line is already selected there is no need to change it.

35 Click on the middle vertical and the middle horizontal border in the Border box.

36 Click on OK.

Observe the result.

A border can also be placed from the toolbar, but the possibilities are limited.

37 Select the range A14:H14 .

38 Click on the botón borde button on the toolbar to select this type of border to place.

39 Click on the All borders option to place all the possible borders in the selection, which in our case would be an outline and a intermediate vertical line.

Observe the result.

40 Select the range A1:H2 .

41 Click on the botón borde button on the toolbar to select this type of border to place.

42 Click on the External borders option to perform a fine outline around the selection.

If we realise that we would like to remove all the borders from a selection we can use the toolbar.

43 Select the range A1:H2 , if not already selected.

44 Click on the botón borde of the toolbar to select this kind of border to place.

45 Click on the None button to remove the borders from the selection.

If we want to remove any of the borders we use the menu.

We will now remove the intermediate line from the range A14:B14.

46 Select the range A14:H14 .

47 Go to the Format menu.

 

48 Select the Cells... option.

49 Click on the Border option if it is not already activated.

50 Click on the intermediate vertical button in the Borders box.

51 Click on OK.

Observe the result.

52 Save the workbook with the same name.

53 Close the workbook.

 



 
 
Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited.
November-2005.