Centring Data in an Excel Cell

If you are following along from the previous sections, you should now have a spreadsheets with cells highlighted. To centre the data in your four highlighted cells, do the following:

When you click on the word "Cells" from the menu bar, you get a dialogue box popping up. The one below:

The words across the top (Number, Alignment, Font, etc) are the headings for Tab Strips. The Tab Strip that is showing is the Number tab strip. We'll meet this one a little later. We need the Alignment Tab Strip, however. So click on the word "Alignment". The dialogue box will change to the one below:

The part of the dialogue box we're interested in is the "Text alignment" section. There are two drop down boxes in this section: Horizontal and Vertical. The Horizontal drop down box has the word "General"; the Vertical drop down box has the word "Bottom" in it. We'll change these.

There are a number of options you can select for the Horizontal text alignment. Click on the word "Center" with your left mouse button. Change the Vertical alignment in exactly the same way. When you're done, click the OK button at the bottom of the dialogue box. Your spreadsheet will look like the one below:

All the data in the cells we highlighted is now centred. Before we do some other formatting, here's something you can try:

What happened? The number you entered should have been centred. The lesson to learn here is that you can format a cell even if there is nothing in it!

OK, let's make our heading bold, and change the font, which we'll do in the next part.

<-- Back One Page Move on to the Next Part -->

<--Back to the Excel Contents Page