How to apply fonts, background colors, and borders in Excel 2010

While working with spreadsheets and workbooks in excel Microsoft, one can use a variety of fonts, background colors and borders to give their data a new and different appearance. You can even use the colors and borders for excel to make one cell stand out against the others or color code information.

Follow this step by step tutorial to learn how to apply fonts, background colors and borders in Excel.


Step # 1 – Click on the “page layout” button

In excel Microsoft, we will look at the three kinds of views that you can use, by going to the lower right corner of the sheet. The middle button is for the “page layout” view. If you press this button, the page layout view will help you view how the sheet will appear when it is printed.

Select the page layout button

Step # 2 – Applying the merge and center feature

Working with headings can often be slightly tricky as one aims to make them stand out against the plain text placed in the worksheet. It is important to make sure the heading is placed in centre of the sheet. Now select all the cells from “A1” to “G1” and then press the “merge and center” button which is given in the “alignment” group under the “home” tab.

Click on the merge and center button

Step # 3 – Choosing the text color

Different colors can also be applied to the heading and in order to do so, click on the heading cell and then click on the text color button which is given in the “fonts” group. A drop down menu will appear in front of you displaying a variety of colors. Click on any one of them in order to apply it to the selected text.

Apply the text color

Step # 4 – Choosing the background color

In order to change the background color of the cell in which the heading is placed, click on the “fill color” button. From the “colors” drop down menu, click on any one color to apply it to the cell background.

Apply the background color

Step # 5 – Opening the border tab

When working with borders for excel and wanting to apply borders to the selected cells, right click on the chosen cell and then click on the “format cells” option. You can even do so by going to the “borders” button given in the “font” group. A dropdown menu will now appear from where you must select the “more borders” option. From the dialogue box that appears, go to the “border” tab and select the specific border you would like to apply to the cells.

Go to the border tab

Step # 6 – Applying borders to selected cells

If you highlight the cells and then click on the border button, borders will be applied to all the selected cells in one go. In this case, we have selected the “all borders” option to be applied to a certain range of cells.

Apply borders to highlighted area