How to create a table with Excel: 12 steps

This article has been written with the collaboration of our editors and qualified researchers to ensure the accuracy and completeness of the content. WikiHow’s content management team carefully examines the work of the editorial team to ensure each item is in compliance with our high quality standards. In this article: Creating a tableChange the table’s appearance Filtering table data You will not need much time to learn how to create a table on Microsoft Excel. You can do this in the same way from the Windows or Mac version of this software. Part 1 Create a table 1 Open an Excel document. Double-click on the document or on the Excel icon and select its name from the home page. This allows you to open a document with hidden columns in Excel. You can also open a new Excel document by clicking Blank Page on the software home page, but you will need to enter your data before proceeding. 2 Choose the table data. Click the cell at the top left of the data group that you want to include, and then hold down ⇧ Shift while clicking the cell at the bottom right of the data group. For example, if you have data in cells from A1 to A5 and to the right to D5, you must click A1, then click D5 while holding down ⇧ Shift. 3 Select the Insert tab. This is a tab with a green ribbon at the top of the Excel window. This allows you to bring up a toolbar just under the ribbon. If you’re on a Mac, make sure you do not click the Insert button on the menu bar. 4 Choose Table. This option is located in the Table section of the toolbar. You should see a window open. 5 Click OK. You will find it at the bottom of the window that opens. This creates the new table. If the data group has cells at the top dedicated to the names of the columns (ie headers), click My Table has headers before selecting OK. Part 2 Change the appearance of the table 1 Touch Appearance. This is the green ribbon at the top of the Excel window. This should open a toolbar directly under the green ribbon. If you do not see it, select the table to make it appear. 2 Select the desired appearance. Click one of the colored boxes in the Table Styles section of the bar to see the color and appearance you want to use. You can click the down arrow to the right of the colored boxes to get more options. 3 Browse through the different options. In the Style Options section of the table, select or clear the following check boxes. Row of headers: by checking this box, you indicate that the cells at the top of the data group are the names of the colones. Uncheck it to eliminate the headers. Total Row: When enabled, this option adds a row at the bottom of the table that displays the total value of the rightmost column. Alternate Color Rows: Check this box to make the rows alternate in two colors, or uncheck them so they are all the same color. First column and Last column: once activated, these options allow to put in bold the headers and the data in the first or the last column. Alternate Color Columns: Check this box to make the columns alternate colors or uncheck them to be all the same color. Filter button: Once activated, this option places a drop-down menu next to each header in the table that allows you to change the data displayed there. 4 Click Home. This will allow you to return to the home page toolbar. Changes in the table should remain the same. Part 3 Filtering Table Data 1 Open the filter menu. Select the drop-down arrow on the right side of the column header where you want to filter the data. A drop-down menu should appear. To get there, you must have the boxes “Row of headers” and “Filter” checked in the section …


Leave a Reply

Your email address will not be published. Required fields are marked *