eHow launches Android app: Get the best of eHow on the go.

How to Make a Table in Excel

Video Preview
From Quick Guide: Excel Training Guide

Summary: Making a table in Excel is as easy as highlighting data, going to the "Insert" tab and clicking on "Table." Select specific fields when making a table in Microsoft Excel with IT help from a software developer in this free video on using computers.

Views:
4,514
Presenter
By Dave Andrews
eHow Presenter

Dave Andrews is a software developer with a business and Web site selling programs and other computer services in Franklin, Tenn. Having worked in the IT industry for more than 8...read more

Post a Comment

Post a Comment

Video Transcript

"Hi, my name is Dave Andrews. Today I'm going to show you how to make a table in Excel. Let's begin by opening up Excel. We'll just click on the start button. We'll go to All Programs. Find Microsoft Office. And let's just launch Excel. Now a table will grant you a whole lot more capabilities for working with your data in Excel than just a regular spreadsheet will. We'll type in some data here, let's just say we're managing our employees, and their number of sales. I'm going to type in some employee names. Now, let's create a table based upon this data that I've just entered To do so, highlight the data using your mouse, go to the insert tab at the top, just click on table. It's going to ask you what fields you want to make your table. I've already got those fields selected, so I'm going to say okay. Now, as you could see, our table - our appearance here has changed a little bit with the headers being highlighted, we've also got some different colors for the rows to kind of distinguish them. Now, what a table will allow you to do that you couldn't do before with your basic spreadsheet is you can click on this little drop down right here, and you can create filters. Let's say I only want to show Dave's records. I'm going to uncheck all of them and then just click on Dave. Now all that we're saying now is Dave, the other two employees have disappeared. They're still there, they're just filtered out. To remove our filter, let's click on that again, and just check clear filters. All my employees have showed up again. That's just one simply easy use that you could do with tables. My name is Dave Andrews and I've just showed you how to create a table in Excel."

eHow Article: How to Make a Table in Excel

Related Ads

  • Have you done this? Click here to let us know.
Computers
Alexia Petrakos,

Meet Alexia Petrakos eHow's Computers Expert.

Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.

eHow Computers
eHow_eHow Technology and Electronics