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.

Orientation is a tool, with the help of it you can change the position of the text in any cell you can give it a new look. For explain this option first of all i'll create a excel sheet with different headlines. Here i typed some Cricket players name and years and i just want to create a table to show which player has scored more runs? But wait, i want to change the look of "Players" cell or say to change its orientation. Let's know what will happen when i change the orientation (after selecting the cell which i want to change): you will observe that at the starting of the options, the direction of the text has given means after selecting the particular option you will oriented your text in these direction..    Now, I think, you must have understood the "Orientation" option. Hope you will like it. Use it and share it.

In this Group you will get the following options: Top Align Middle Align Bottom Align Left Align Center Align Right Align Orientation Decrease Indent Increase Indent Text Wrap  Merge And Center We will know about all of above one by one. The "Alignment Group" looks like this: Top Align Middle Align Bottom Align Left Align Center Align Right Align I'll explain all above options together in a single image : When You observe the pattern of the text in the cells you will find that  : Top Align            -    In top alignment Text appears on the top of the cell. Middle Align       -    In middle alignment Text appears on the Middle of the cell. Bottom Align      -    In bottom alignment Text appears on the bottom of the cell. Left Align           -    In left alignment Text appears on the left of the cell. Center Align       -    In ...