Adding data to a spreadsheet in Excel 2013 gives you the ability to sort data, edit it, and perform a number of different mathematical operations and functions on it. But occasionally you might have data that needs some additional formatting or filtering options, in which case it’s helpful to know how to make a table in Excel 2013.
Our tutorial below will show you how to create a table from data in your spreadsheet, then customize the design of that data, filter it, or even convert it back into a standard range if you decide that you don’t need or don’t like the table layout. So continue below and find out how to make a table in Excel 2013.
How to Create a Table in Excel 2013
The steps in this article are going to show you how to select data in a Microsoft Excel spreadsheet and convert it into a table. Once you have created a table in Excel 2013 you will be able to customize the design of that table, or filter it so that only some of the data appears in the table. For the sake of this guide we will assume that you already have the data in your spreadsheet, and that the data has headers. If you don’t have headers (a row at the top of the spreadsheet that identifies the data in the columns) then you may want to add a header row to make this process a little easier.
Step 1: Open the spreadsheet in Excel 2013 that contains the data you want to turn into a table.
Step 2: Select the data in the spreadsheet that you wish to turn into a table.
Step 3: Click the Insert tab at the top of the window.
Step 4: Select the Table option.
Step 5: Check the box to the left of My table has headers (if it’s not already checked) then click the OK button.
How to Change the Appearance of Your Table in Excel 2013
Now that you have created a table in your spreadsheet, it’s a good idea to customize its appearance. This section will show you how to adjust the design of the table to make it look better and make it easier to work with.
Step 1: Select the entire table, then click the Design tab at the top of the window.
Step 2: Select one of the designs from the Table Styles section of the ribbon.
Step 3: Check or uncheck any of the options in the Table Style Options section of the ribbon.
For reference, these options mean:
- Header Row – check this box if your table has a header row, which identifies the information contained in each column
- Total Row – Check this box to include a Total cell at the bottom of the table for the rightmost column
- Banded Rows – Check this option if you want the colors of the table rows to alternate automatically
- First Column – Check this option to bold all of the values in the first column
- Last Column – Check this option to bold all of the values in the rightmost column
- Banded Columns – Check this option to alternate the colors of each row. This can conflict with the Banded Rows option, so it’s typically best to choose one or the other.
- Filter Button – Check this box to add a dropdown arrow to the right of each column heading which lets you perform the filtering options we will discuss in the next section.
How to Filter a Table in Excel 2013
The steps in this section are going to show you how to use the filtering capabilities of the table that you have created. if you don’t see the filtering dropdown menu that we will be using, make sure that you are using header rows, and that you have checked the Filter Button option discussed in the previous section.
Step 1: Click the dropdown arrow to the right of the column header for the column data that you want to filter.
Step 2: Choose the Sort A to Z option to filter the data in that column with the smallest value at the top, or choose the Sort Z to A option to filter the data with the largest value at the top. Alternatively you can select the Sort by Color option if you have set custom colors for different rows and want to sort that way.
Step 3: Select the Text filters option and choose one of the items there if you wish to filter your data in this manner, or check and uncheck values in the list at the bottom to display or hide certain values.
How to Delete the Table and Convert it Back to a Range
The steps in this section will show you how to remove the table formatting and turn it back into a standard range like it was before you turned it into a table. This won’t delete any of the data in the table, but will remove the filtering options and any design or these settings you have created.
Step 1: Right-click one of the cells in the table to bring up the shortcut menu.
Step 2: Select the Table option, then choose the Convert to Range option.
Step 13: Click the Yes button to confirm that you would like to convert the table back to a normal range.
One of the biggest frustrations that comes from working with Excel is when you need to print. Check out our Excel printing guide that will give you some tips on ways to improve the printing process for your spreadsheets.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.