Saturday, July 2, 2011

Formatting in Excel -> Part 2

As we have seen in Part 1
http://saxenablogs.blogspot.com/2011/07/formatting-in-excel.html

how to make bold and border of cell let us explore more features

We have our activities defined in excel as shown below
Now to make the the ITEM and PRICE Header of our excel filled with color do the the following

click on ITEM & PRICE Cell as shown


Now click on the ICON as shown for filling and choose your required color
now this will make our cells filled with color as shown

Thus to make color different of Text choose the cell and click on the icon as shown


This will convert our Header Text Color to the choosen color as shown below


Above steps cover the way to change the Cell color and Text color.
As we can notice that we can change the color of Cell Background and also the Text color so easily we can also change the font size too which we explore later

To know how change the font & its size etc in Excel please click here

http://saxenablogs.blogspot.com/2011/07/formatting-in-excel-part-3.html

No comments:

Post a Comment