Home » Resources » Excel 2007 Tutorial » Default Border Settings

As well as being able to draw borders by hand, Excel also provides some pre-set options that you can apply to groups of cells. This will be covered in our Microsoft Excel Course.

To do this, highlight the cells that you wish to affect and then, using the “Border Options” button in the Formatting section of the ribbon, select the border Style you want around them. The options are in the top section of the  drop down menu under “Borders” as shown below:

Tip: To save time, simply pressing the Border button will apply the border style you used last which will save you having to choose it from the drop-down menu each time.

Similar resources you may like

1. Saving and Closing
2. Formatting Numbers
3. Drawing Borders
4. Customising Borders and Cell Size
5. Excel Functions

Tags

borders, Excel, Excel 2007 Tutorial, excel training, excel tutorial, microsoft, microsoft excel, microsoft office, resource, resources, training

Share This Resource

This entry was posted by Alistair Wylie on Wednesday, May 6th, 2009 at 12:51 pm and is filed under Excel 2007 Tutorial. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.