Innovative Ways To Format Tables- Using Excel Table Format

Part -9 – Excel Table Format 

Download Excel Templates – Excel Table Format 

Excel Format – Excel Table Format (without solution)

Excel Format – Excel Table Format (with solution)

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.

Recommended Articles

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.

1. Number Format In Excel
2. VBA Macro
3. Advanced Excel Formulas and Functions
4. Pivot Chart in Excel