How do you create table in Microsoft Excel?

Answer 1

There are a few ways to do this. First, you can simply hit "Cntrl + N", or select file menu and select "new".

sdloco

Here is a good tips and tricks site for everything excel

http://www.zettalogix.com/Excel_Tips_And_Tricks.html

Answer 2

Open Microsoft Excel and start making your workbook. When you are done, save the workbook. Or, if you are already editing a workbook, click "new..." (file-->new... in M.E. 2003) to create a new workbook.

Answer 3

In the context of Excel a table could mean different things. At its simplest it could be just a set of data in a rectangular area of columns and rows. Normally the first row will have headings for each column of data. In that case all you have to do is type in the headings and the data.

For something a little more functional, like enabling you to sort and filter data, you can enter the data as above, select it all, and then pick the table option and it will use the headings to be like field headings in a database table and then enable you to do the sort and filtering by clicking on the arrows that will have appeared in each heading cell.

There are also other kinds of tables like What-If tables and Pivot Tables. You can create one-input and two-input tables to create a table of calculated data. So it all depends on what it is you want to be able to do that will determine what kind of table you create.

Answer 4

First open the file. Then you can make whatever changes are needed. Pressing the F2 key is one way of starting to edit a cell. You can also just start to type directly into it. Once you have made the changes you need then you can save the file.

Answer 5

Use the keyboard shortcut Ctrl - N as the quickest option. You could use the File menu and New option.