Gaurav Blog

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...

Number Group : In this post we will know about the formats of  Text. Generally in excel sheet we have need several types of number/text formats and this Tab helps us to fulfill our needs.  First of all i want to show you how does it look.. Actually this Tab give us a freedom to choose that how will our text displayed. For example if we type a number in any cell and then we can apply any formula like multiply, divide, sum, percents etc. but if we select the cell and change the Number format in to Text Format then multiply, divide... will not work because they can be perform on Numbers not on Text.  About this we will know step by Step in next post till then Have a good day.

Merge and Center Happy Monday, Today is the last day of "Alignment Group" because today we'll know about the last option, What is this made for ? and how does it work? First of all i would like to show you how does it look? and where can we find it. okay , so the following image is showing the "Merge and Center" option on "Alignment Group" : In circled area you can find the option. It is use for merge the cell or in other words we can say that it is use for join the selected cells to make a larger cell and center align the text. How does it work ? Let's see: Here is a bill of a book seller, in this image you will not found the name of shop because of cells that are not merged,  they can not hold larger text. So if you want to Correct it then Select the cell in which you want to put the name of Shop and click on merge and center and you will found a larger cell in which you can put your text. As following: After selecting the option:   At last you c...

Wrap Text  This is a ultimate option in MS Excel. It is use for displaying the text in single cell in multiple lines. Many times it happens that we have to do a lot in 1 cell but But we do not have to increase the length of the cell. In this case mostly our text is hidden by another cell. Therefore to solve this problem we can use the option "Wrap Text". Let's understand it by a example.. I have to create a worksheet with a lot of URL link. so how can i use it let's watch..... Whenever this type of data we have to handle we can use "Wrap Text" to hold it in a cell. First of all we have to select that cells on which we want to work then select "Wrap Text". You don't need to select whole text only select the cell in which large data has contain. Look it here Now You see that the whole data is managed in a cell but after selecting the "Wrap Text" you have to manage the height and width of cell according to the contained data.