Home » Resources » Excel 2007 Tutorial » Drawing Borders

Most spreadheets have some sort of formatting applied to them to make them easier to read and understand. Often you will want to create a border around a group of cells to differentiate them from others, or to put them in to a table.

There are two main ways that you can create a border in Excel.

The first is to draw the border using your mouse. You can draw a border along any cells you wish either horizontally or vertically. To do this: select the “Border options” button from the ribbon; this is the small arrow to the right of the actual “Border” button. This will display a list of options – click on the “Draw Border Line” option in the lower section of the list under the heading “Drawing Borders.”

With this option selected, your mouse cursor will become a pencil. You can now create borders by pressing and holding the left mouse button from where you want to start and dragging it to where you want it to end. You can either create a straight line or drag around a group of cells to draw a box around them.

If you want to draw a grid within your box use the “Draw Border Grid” button beneath the “Draw Border Line” option you used before.

 

All of this is covered in our Beginners Excel Training Course. Once you have mastered these skills you will be ready to attend our Advanced Excel Training Course, and really advanced might want to try VBA for Excel.

Similar resources you may like

1. Highlighting Cells
2. Auto Sum
3. Formatting Numbers
4. Default Border Settings
5. Customising Borders and Cell Size

Tags

borders, drawing, Excel, Excel 2007 Tutorial, Free, micorsoft office, microsoft excel, spreadsheet, top Tips, training, Tutorial

Share This Resource

This entry was posted by Alistair Wylie on Wednesday, May 6th, 2009 at 12:47 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.