Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How can I insert a table in Microsoft excel?

user-image
Question ajoutée par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date de publication: 2015/05/22
Shaik Muhammed Manayil
par Shaik Muhammed Manayil , ICT Manager , Emerald Properties LLC

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

 

Step1

 

 

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

 

zia uddin
par zia uddin , Quality Inspector , PREVAIL ENGINEERS

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

Mohammad Basheer abu ahmad
par Mohammad Basheer abu ahmad , مشرف كمبيوتر ، الإشراف على الموظفين , قطاع عام

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

Utilisateur supprimé
par Utilisateur supprimé

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.

Utilisateur supprimé
par Utilisateur supprimé

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

Faizan Mukaddam
par Faizan Mukaddam , Researcher - Client Servicing , TNS Middle East & Africa Ltd

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

Umesh kharwar Sonu Kharwar
par Umesh kharwar Sonu Kharwar , Data Entry Clerk , Al Jaber L.E.G.T. Engineering & Contracting (ALEC)L.L.C.

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.

 

 

Firas Shahadi
par Firas Shahadi , Human Resources Director , SAUDI UNION

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

Ctrl+T

Ahmed Maher
par Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)

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

Pankaj Singh- CMRP
par Pankaj Singh- CMRP , Senior Reliability Engineer , Marafeq Qatar

go to insert tab-  select -insert table

Minhaj Azeem Abbasi
par Minhaj Azeem Abbasi , Business Analyst , Cisco Systems Inc.

A simple and quick way to do it by selecting your range and pressing ctrl+T.

More Questions Like This