In Excel, you can choose to apply a table style to any table with the next cell. So in order to do that, go ahead and begin by selecting the section of your worksheet that you want to put into the table. Then in your style section and this is on the home tab, go ahead and click on format as table and you’re going to come up with these options and you have some light colored options and medium colors and some dark colors.
So go ahead and find one that you like and go ahead a click on it to apply that table style. Before it applies that table style, you’re going to be asked to confirm what data you want to be formatted as a table.
Now we already had our data selected, so it automatically inserted that here. If you didn’t select it before, all you do is you need to press this button and then go through and select it and it will be inserted. Click this button again and you’ll go back to the Create Table dialog box. You could check this box if your table has headers which it might does has some header so I m going to go ahead and leave that. Click OK and it automatically formatted my table.
Up here I now have a design tab and I have some table style options that I can apply to my table. My header row, if I don’t want the header row, I could go ahead and unchecked to get that cleared off. I can have a total row which you just add to total row at the bottom, banded rows which I already had and went ahead and took off. You could choose to have special formatting applied to your first column and to your last column and you can also choose to have banded columns. So those are some of the ways that you can apply and customize your table style.
Transcription by:
Scribe4you Transcription Services