Register now or log in to join your professional community.
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
