Convert Data Into a Table in Excel

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

Convert Data Into a Table in Excel

How to convert data in Excel into a table 

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