Home » Resources » Excel 2007 Tutorial » Customising Borders and Cell Size

Customising Borders

In addition to the standard templates in Excel 2007, you can also customise your borders, adjusting their width, colour and line style. These options are contained in the Formatting section of the ribbon and the Border Options button. All of this is covered in our Beginners Excel Training Course.

You can also, as in Microsoft Word, change the font and style of the figures and words that you put into your cells, as well as being able to change their size and underline them. Simply highlight the cells you want to format and then select the appropriate border, font and text formatting options you require from the Formatting section.

Changing Cell Size

We’ve already explored how to wrap text to make it fit in to a small cell – however it is also possible to change the width and height of the cell columns and rows themselves.

To alter the row height, move your cursor over the column on the far left of your screen, to the left of A1, where the numbers of the rows are shown. Hover the mouse arrow over the division between two cells, i.e. the top of A2 and the bottom of A1, until it changes to an icon shaped like a cross with directional arrows at either end. Now all you need to do is click and hold the left mouse button and drag the up or down and the height of the cell row will change. The same method is used for changing the width of the cells, by clicking on the divisions between the columns at the top of the spreadsheet.

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. Formatting and Formulas
2. Auto Sum
3. Formatting Numbers
4. Drawing Borders
5. Default Border Settings

Tags

borders, Cell Size, Excel, Excel 2007 Tutorial, excel training, excel tutorial, formatting, Free, micorsoft office, microsoft, microsoft excel, numbers, Spreadsheets, Tips, top Tips, training

Share This Resource

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