How can I insert a table in Microsoft excel?

hi

if you want insert table from other data sources such as SQL Server , MS access Data base , oracle  etc it is possible . please follow the steps

Excel > Data Tab > From Other sources > from SQL server

you will get a wizard to connect SQL server

Enter server name \\ instance name ( if you have multiple instance )

or just type server IP or server name

enter user name and password > click next

choose database and table you need > click next > click finish > click ok

if ask password again please enter > click ok

The data will be displayed on excel

Now the table you can refresh   by clicking  refresh all in data section . as soon as the  user update its can be seen after refresh

Enjoy !!!

Keep in touch

first u select any cell and right click then generate a menu select Insert Row. Just :)  

You can select (Insert) from list then click on (Table) option

Insert Table on the "Insert Tab/ribbon" function  will insert a pivot table.

Alternative, if you want a table, that is for a presentation or to be set up with data filters, then by

completing the column headings, and first column row left hand board names, complete the table data in normal text, then on the "standard ribbon" click the "format as a table" button and select a design that is suitable.

excel is a big table so, u need just to add border to group of cell to insert table to your sheet 

The reason why excel is different than MS word is because Excel in itself is a table by default

Firs Open the Microsoft excel, completing the column headings, and first column row left hand board names, complete the table data in normal text, then on the "standard ribbon" click the "format as a table" button and select a design that is suitable.

Quick Tip: select any cell from the data you want to change to table and use this shortcut:

Ctrl+T

wirte your heading or content and select all border to be as distinct table

go to insert tab-  select -insert table