Saturday, July 2, 2011

Formatting in Excel -> Part 1

Based upon usage we can always make good looking database in excel i.e well arranged and easy to read

say for e.g we have done certain entries in excel as shown below

Eventhough we can see the Column header as ITEM and PRICE with TOTAL as the overall sum for the values of price but this sheet is very normal and don't look nice it is good but we can make it nice as follows

Just choose the cell ITEM & PRICE as shown below
Now to make them BOLD in excel just click on the B icon ass shown
This will cause them to make Bold of our Header as shown
As we can see the Header are now BOLD and beautiful so lets go to next thing we want to do

Let us make them highlighted  with a border as we text only in few columns and not all to do that select the cell as shown
Now click on Border key and choose as shown
This will make our Cells all bordered as want them
Thus above are 2 special formatting features which we do in our daily routine activities in excel including Bold and Border making we explore more soon.


No comments:

Post a Comment