How to Make Tables Using Microsoft Excel
This wikiHow teaches you how to create a table of information in Microsoft Excel. You can do this on both Windows and Mac versions of Excel. Open your Excel document. Double-click the Excel document, or double-click the Excel icon and then...
Part 1 of 3:
Creating a Table
-
Picture 1 of How to Make Tables Using Microsoft Excel Open your Excel document. Double-click the Excel document, or double-click the Excel icon and then select the document's name from the home page.- You can also open a new Excel document by clicking Blank Workbook on the Excel home page, but you'll need to input your data before continuing.
-
Picture 2 of How to Make Tables Using Microsoft Excel Select your table's data. Click the cell in the top-left corner of the data group you want to include in your table, then hold down ⇧ Shift while clicking the bottom-right cell in the data group.- For example: if you have data in cells A1 down to A5 and over to D5, you would click A1 and then click D5 while holding ⇧ Shift.
-
Picture 3 of How to Make Tables Using Microsoft Excel Click the Insert tab. It's a tab in the green ribbon at the top of the Excel window. Doing so will display the Insert toolbar below the green ribbon.- If you're on a Mac, make sure you don't click the Insert menu item in your Mac's menu bar.
-
Picture 4 of How to Make Tables Using Microsoft Excel Click Table. This option is in the "Tables" section of the toolbar. Clicking it brings up a pop-up window. -
Picture 5 of How to Make Tables Using Microsoft Excel Click OK. It's at the bottom of the pop-up window. Doing so will create your table.- If your data group has cells at the top of it that are dedicated to column names (e.g., headers), click the "My table has headers" checkbox before you click OK.
Part 2 of 3:
Changing the Table's Design
-
Picture 6 of How to Make Tables Using Microsoft Excel Click the Design tab. It's in the green ribbon near the top of the Excel window. This will open a toolbar for your table's design directly below the green ribbon.- If you don't see this tab, click your table to prompt it to appear.
-
Picture 7 of How to Make Tables Using Microsoft Excel Select a design scheme. Click one of the colored boxes in the "Table Styles" section of the Design toolbar to apply the color and design to your table.- You can click the downward-facing arrow to the right of the colored boxes to scroll through different design options.
-
Picture 8 of How to Make Tables Using Microsoft Excel Review the other design options. In the "Table Style Options" section of the toolbar, check or uncheck any of the following boxes:- Header Row - Checking this box places column names in the top cell of the data group. Uncheck this box to remove headers.
- Total Row - When enabled, this option adds a row at the bottom of the table that displays the total value of the right-most column.
- Banded Rows - Check this box to color in alternating rows, or uncheck it to leave all rows in your table the same color.
- First Column and Last Column - When enabled, these options make the headers and data in the first and/or last columns bold.
- Banded Columns - Check this box to color in alternating columns, or uncheck it to leave all columns in your table the same color.
- Filter Button - When checked, this box places a drop-down box next to each header in your table that allows you to change the data displayed in that column.
-
Picture 9 of How to Make Tables Using Microsoft Excel Click the Home tab again. This will take you back to the Home toolbar. Your table's changes will remain.
Part 3 of 3:
Filtering Table Data
-
Picture 10 of How to Make Tables Using Microsoft Excel Open the filter menu. Click the drop-down arrow to the right of the header for the column whose data you want to filter. A drop-down menu will appear.- In order to do this, you must have both the "Header Row" and the "Filter" boxes checked in the "Table Style Options" section of the Design tab.
-
Picture 11 of How to Make Tables Using Microsoft Excel Select a filter. Click one of the following options in the drop-down menu:- Sort Smallest to Largest
- Sort Largest to Smallest
- You may also have additional options such as Sort by Color or Number Filters depending on your data. If so, you can select one of these options and then click a filter in the pop-out menu.
-
Picture 12 of How to Make Tables Using Microsoft Excel Click OK if prompted. Depending on the filter you choose, you may also have to select a range or a different type of data before you can continue. Your filter will be applied to your table.
Update 05 March 2020
You should read it
- 35 tools, scripts and plugins to build HTML Table
- Hash Table data structure
- MS Access - Lesson 5: Create a table
- MS Access 2003 - Lesson 12: Working with a table
- TEMPORARY TABLE temporary table in SQL
- Navigate directly from table to table in Word 2013
- Query XML data from a table with XML data type
- How to Add Columns in a Pivot Table
- CLONE TABLE in SQL
- How to create a table and insert a table in Excel?
- Types of data center design
- Manipulating tables in Excel