Excel: Convert Data Into an Excel Table

Create 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.

Change 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

Help Page Feedback