Part -9 – Excel Table Format
Download Excel Templates – Excel Table Format
Learn how to organise, format and calculate data smoothly. Develop skills to master excel tools, formulae and function. Analyze data from different perspectives.
Transcript For The Video – Excel Table Format
Now that we done with the number formatting let’s look at how we format over all table and text content here. so let us take a preview on how it looks like as of now let us click on file and print and don’t worry about you know how to print because we will be discussing this in details what we must be concerned at this stage is the look and feel of the overall tables so I would encourage you to look here on the right hand side and see if this table is making sense to you ideally speaking this table can be improved in terms of formatting in a much more detail. So let’s look at you know ways and mechanism of improving this formatting and for this let us go back to the home page and here is the sub titles of the table. The first thing that we can be do with this excel sheet is to shift the heading of the tables form the left hand corner to the top of the table so that we can do using a cut command let us say we right click on cell A1 we do a cut and we paste it in cell P2 by right clicking and paste so what happens is this cell is immediately above the overall table now in order to center this. on the table we can use this function called merge & center so if you can click here you will find that this heading or the number calls will get merged & heading will be at the center this what we wanted at the first place heading of the table should be at the top now the second thing that we may like to note here is that many of the text is not readable at all say for example department so for this we know how to work on this we can click between DNE Double click and all things will get aligned what else can we do now look at the serial number 1 ,2 is really aloof 3,4,5,6,7,8,9,10,till 18 all are on the right hand indent so what can do is we can make them as work on the center so this a small thing that we can work on in terms of formatting the serial number for formatting the text you need to remember that there are different kind of formats and fonts which are available you can actually change the color of the font if you want say for example if you want to change the colors of names form black to Blue or Green or Oranges you can as simply do that by selecting them however for our purposes we will keep these fonts as black itself. Let us try to make the this formatting a bit more visually appealing and intuitive the thing that we can do since these are heading we can use Bold at the top by clicking on bold these heading gets highlighted likewise these titles here we can again bold it by clicking here the other thing that we can do is we can select if you look at the top you will find that there are outside border which are mentioned there are different kind of borders and formations which are available if you let us say want to format or keep borders across the table here what we can do is we can select this full table and click on all borders so what will happen is borders will be formed across the table as such so this is how you know the border may function there are different kinds of the border options the bottom border, the Top border, left border ,Right border let us try to make another use of the border let us say for examples if you want to border this overall area in totality we don’t want the border inside these cells but the overall border so what we can do is we can select this whole area we go to the border and we can select outside borders that what we want in this cases and we press the outside border and we find that outside border is now visible we may also make these headings as bold in addition what we can also do is probably look at formatting this cell in terms of different colors there is different colors that we can use let us say if you want to use yellow colors in order to highlight the topic or may be different combination of colors which you like let us say oranges and may be a different color combination for these cells for different sub tittles let me choose this one and this is how you know we can look at formatting let us now go back and look at an print preview and see how it looks as compares to the previous version and yes it may not be totally formatted we can still look at ways and mechanisms of improving this formatting at this stage however this look good to go in the first case. Now having formatted the table in the very traditional way where we had used borders and fill colors these kind of options this is a reasonable table format that we have kind of created however if you would like to make use of the automated format which are provided by Microsoft Excel these also provides very professional way of making tables say for example if you go to home and click on format as tables you will find that there are different kind of options which are available in a predetermined set of format any set of format which you may like to choose depending on your personal colors choices you can actually make the most of it so let us try to use these set of formats to automatically format the table at hand so let me go back and by default change the color combination which were used initially Now what we need to do next is select the table and go to format as table and as you can see that there are various kind of options you may choose table style light 9 this may be one of the option and as you can see where is the data for your table the data for your table is not at the K2 here but data for the table is essentially starting from serial number, name, department till the very end .so this is the selection which you have to make for the table and next thing that you should note is that this thing should be checked if you have the table header so my table has a header, header means serial number, name, departments all these are the table headers and once you are done with this just press O.K. you may see that there are some kind of professional style that gets into these tables and which are determined automatically. So like if you want to change a table style just a click away so this are also effective professional ways changing or making the tables and formatting the tables.
Here are some articles that will help you to get more detail about the Format Tables- Using Excel Table Format so just go through the link.