Border In Sheet

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 option "Top Border" and "Bottom Border" one by one from the drop down list. 

and you will get the following result (On Print Preview): 






It is looking much better then before. But if you want that every cell has surrounding border then use "Border Grid" from the drop down list. As you select the "Border Grid" option you will get a pencil, turn round it on the sheet or data on which you want grid. 


You will get the following result:






After all you will get the following print preview which is much better then without border: 

Thank You for visit. 


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

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