Excel: Convert Data Into an Excel Table

Excel: Convert Data Into an Excel 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. Select 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. (Use Live Preview to view available choices.)

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

Atomic Learning Video Email this to a Friend

Help Page Feedback

Did this content help you? *

What is your opinion about the content? *

Suggest new content or let us know how we can improve this content (optional):

If you desire a response, please provide your email address (optional):

Leave this field empty