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 in Brighton, Sussex.

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.

Related posts:

1. Spreadsheets
2. Text Wrapping
3. Formatting and Formulas
4. Formatting Numbers
5. Drawing Borders

Similar resources you may like

Related posts:

1. Spreadsheets
2. Text Wrapping
3. Formatting and Formulas
4. Formatting Numbers
5. Drawing Borders

Tags

borders, Excel, excel training, excel training sussex, excel tutorial, microsoft, microsoft excel, Microsoft Office, resource, resources, sussex, Training

Share This Resource

• Digg
• Twitter
• Stumbleupon
• Delicious
• Facebook
• Myspace
• Google
• Technorati
• Newsvine