How to Format an Excel Spreadsheet as a Table

This document is intended to show users how to format a data set as a table in Excel.

First, open your excel document.

2017-10-27_9-18-02.jpg

Once open select the top left cell of the data set

2017-10-27_9-18-13.jpg

Next, scroll to the bottom of the data set Press and hold the Shift key on your keyboard, then Click in the bottom right cell of the data you want to format as a table

2017-10-27_9-18-27.jpg

Make sure that you're on the Home tab, then click "Format as Table"

2017-10-27_9-19-01.jpg

Select a table design, this is completely up to you what color scheme you want.

2017-10-27_9-19-20.jpg

A box will appear. Check "My table has headers" if your data already has a header column, like the one pictured, and you selected it. Click OK

2017-10-27_9-19-54.jpg

Now your data should be in a table. You can click the arrow in each column header and see Values that can be selected and de-selected as necessary. You can also choose to sort in this box. This will arrange the table data by this column.

2017-10-27_9-21-35.jpg

Once you've selected the data you want to see click OK

2017-10-27_9-22-07.jpg

Your table will display the results

2017-10-27_9-22-19.jpg

Have more questions? Submit a request

Comments