Convert Data Into a Table in Excel

1. Top 10 Help Pages
2. Recent Additions
3. Instructions
4. Show All Help Pages
5. Search Help Pages
6. Contact Information
7. Atomic Learning
8. CedarInfo
9. CedarNet
10. Google Apps
11. Google Calendar
12. Google Drive
13. Google Groups
14. Google Mail
15. Google Sites
16. Microsoft Excel
17. Microsoft Outlook
18. Microsoft PowerPoint
19. Microsoft Word
20. Miscellaneous
21. Moodle
22. Other Software
23. Personal Computers and Devices
24. TechStop
25. University Hardware
26. Windows

Convert Data Into a Table in Excel

 

This page will show you how to convert Excel data into a table.

Creating a Table within Excel

1. Open the Excel spreadsheet.
2. Use your mouse to select the cells that contain the information for the table. 
3. Click the "Insert" tab > Locate the "Tables" group.
4. Click "Table". A "Create Table" dialog box will open. 
5. If you have column headings, check the box "My table has headers".
6. Verify that the range is correct > Click [OK].
7. Resize your columns to make the headings visible.

Changing the Table Style

1. Click on a cell in the table to activate the "Table Tools" tab.
2. Click the "Design" tab > Locate the "Table Styles" group.
3. Choose a style/color option that appeals to you. (Hover over the various table styles to see a live preview.)

Keywords: Office, color, colors, filter, sort, rows, columns, apply, enhance, table

Posted in Computer Help