Color The Cell

Today, we will know about last options of "Font Tab". They are "Fill Color" and "Font Color". Generally when you see these option you will get confuse What's the thing for that? but i will explain you that how can we use it in proper way and for what, they are designed?

Take a look on them...


The First one is for color the cell, means this one change only cell color (Not Text in the cell). And another one is for text in the cell means it will change the color of the text in the cell not cell.


Look it here i have an example to show you how do they work:


Let's a table with different items:



Step 1 : If i select any one Row Or column and go to the first one it will appear "Fill Color" and after selecting the option you will get the following result:  



Step 2 : If i select any one Row Or Column and go to another one it will appear "Font Color" and when you select this you will get the following result:



In the above two images, if you observe you find in first image, only cell color is changed not text, but in next image only text color is changed not cell.

So this is the use of the options. I hope you will like this post and blog. Please share your opinion, and keep visiting this blog









Comments

Post a Comment

Popular posts from this blog

Font Group

Image
Hii Friends, Yesterday, we have talked about the "clipboard Group" in "Home Tab". But Today we will know about the next group of  Home Tab in MS EXCEL. It is "Font Group". It is very simple and easy to use tool. We can simply understand every option of it. But still i want to explain every thing so that you don't have any problem/doubt to use it. Let's start............. It looks like this  1. Font "Calibri" is the type of Font. In simple language we can say that if we change the font, we change style of writing. For Example if i select a filled cell and then change the font............ take a look what happens. It is the "Calibri" font but if change it by clicking on down arrow near "Calibri", look what happens..  So, you can watch that the style of font has changed. Simply we can change it in several styles.  Note: "For Select any cell you will have to left click on them by mouse. But if you want to select more...
Read more

Border In Sheet

Image
Today we will know about a very useful thing about excel sheet. Generally we create any sheet in excel and print it but without border it will not look pretty and the document will not get a professional look. Therefor it is compulsory that we use "Border Option". Take a look if do not use border then how will our print preview.... Here, i note some records but if we print and it we don't find it in proper manner. Let's check it by print preview.... After Select "Print Preview" we will found the following result....... Here, records are not in proper way also not looking good. So if we want to give it a proper look we have to use "Border" option in "Home Tab" "Font Group"  When put your mouse cursor on the down-arrow of  border option you will get a list that which type of border do you need?? for example: If you need only "Top and Bottom Border" then select the cells on which you want to border and then select the opt...
Read more

Number Group

Image
Hello Friends, Happy Friday After a long time i come to show you how can we use "Number Group" in Home Tab . With the help of this group we can change the " format of  text" for example i just type a number in any cell of excel and want to use this number as a date so simply i can choose "Date" option from the list of number format. Let's understand it by a example: In this picture, if you observe the format "Starting date" and "End Date" is "Date" and in Duration you can observe that given content is a number. This is all because of Number format. Actually Excel take every date as a number and for Excel 01 January 1900 = 1 02 January 1900 =2 ............. ............. .............. this way every date has a special number and excel use it as a number but for us it format its like a date. so when we use a formula to get duration is work as a number and give a result in a number format and if we change the format of Durat...
Read more