HomeApplicationOffice information

How to Make Tables Using Microsoft Excel

Part 1 of 3:

Creating a Table

  1. How to Make Tables Using Microsoft Excel Picture 1
    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.
    1. 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.
  2. How to Make Tables Using Microsoft Excel Picture 2
    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.
    1. 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.
  3. How to Make Tables Using Microsoft Excel Picture 3
    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.
    1. If you're on a Mac, make sure you don't click the Insert menu item in your Mac's menu bar.
  4. How to Make Tables Using Microsoft Excel Picture 4
    Click Table. This option is in the "Tables" section of the toolbar. Clicking it brings up a pop-up window.
  5. How to Make Tables Using Microsoft Excel Picture 5
    Click OK. It's at the bottom of the pop-up window. Doing so will create your table.
    1. 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

  1. How to Make Tables Using Microsoft Excel Picture 6
    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.
    1. If you don't see this tab, click your table to prompt it to appear.
  2. How to Make Tables Using Microsoft Excel Picture 7
    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.
    1. You can click the downward-facing arrow to the right of the colored boxes to scroll through different design options.
  3. How to Make Tables Using Microsoft Excel Picture 8
    Review the other design options. In the "Table Style Options" section of the toolbar, check or uncheck any of the following boxes:
    1. Header Row - Checking this box places column names in the top cell of the data group. Uncheck this box to remove headers.
    2. 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.
    3. Banded Rows - Check this box to color in alternating rows, or uncheck it to leave all rows in your table the same color.
    4. First Column and Last Column - When enabled, these options make the headers and data in the first and/or last columns bold.
    5. Banded Columns - Check this box to color in alternating columns, or uncheck it to leave all columns in your table the same color.
    6. 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.
  4. How to Make Tables Using Microsoft Excel Picture 9
    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

  1. How to Make Tables Using Microsoft Excel Picture 10
    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.
    1. 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.
  2. How to Make Tables Using Microsoft Excel Picture 11
    Select a filter. Click one of the following options in the drop-down menu:
    1. Sort Smallest to Largest
    2. Sort Largest to Smallest
    3. 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.
  3. How to Make Tables Using Microsoft Excel Picture 12
    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.
4 ★ | 1 Vote
clicktabledatadesign

You should read it

May be interested

  • Instructions to delete 0, hide 0 in ExcelInstructions to delete 0, hide 0 in Excel
    when working on excel, with statistics tables with 0, users can completely hide or hide the number 0 with the tools available on the system.
  • Use VLOOKUP to join two Excel tables togetherUse VLOOKUP to join two Excel tables together
    connecting columns of this table to another table is often complicated because the rows in this table do not always correspond to the other table. by using vlookup to join the table you will avoid these annoying sorting problems.
  • MS Excel - Lesson 4: Working with lines, columns, sheetsMS Excel - Lesson 4: Working with lines, columns, sheets
    in addition to the content of tables in excel, operations with lines, columns and sheets in this program are also important. in this article, tipsmake.com will guide you to simple operation to add or remove lines, columns or sheets in excel tables.
  • MS Excel 2003 - Lesson 1: Get familiar with Microsoft ExcelMS Excel 2003 - Lesson 1: Get familiar with Microsoft Excel
    excel 2003 spreadsheet has a maximum of 256 columns and 65,536 lines; the maximum number of worksheets you can add is 255 sheets. with this huge number, managing tables will become much simpler.
  • How to repeat titles in Excel 2007, 2010 and 2013 when printingHow to repeat titles in Excel 2007, 2010 and 2013 when printing
    when printing excel with multi-page content, if we let the title appear on each page, the reader can visualize the content of the spreadsheet or statistics table, without having to go back to the first page to see the title. .
  • Manipulating tables in ExcelManipulating tables in Excel
    guide you to create tables in excel. to create the table you perform the following steps: step 1: go to the insert - tables - table tab: step 2: the create table dialog box appears - in the where is the data for your table section select the data area to create the table - ok .
  • How to create a table and insert a table in Excel?How to create a table and insert a table in Excel?
    for better data management in excel, creating tables for excel data is essential. you can easily search, calculate, manage and analyze data ... but the way to create tables is very simple, so you can quickly create tables in the
  • How to use NORMDIST function in ExcelHow to use NORMDIST function in Excel
    normdist is a function that returns a distribution with a standard deviation and a confirmed average. the normdist function applies in statistics, including hypothesis testing.
  • Manipulating tables editing in ExcelManipulating tables editing in Excel
    instructions to manipulate tables in excel. 1. insert rows and columns in the table: - for example, want to insert 1 column after salary column 1 day: step 1: select the column number of days - go to home - cells tab - insert - insert sheet column.
  • How to fix the SUM function doesn't add up in ExcelHow to fix the SUM function doesn't add up in Excel
    in the process of summing with sum in excel, you will encounter some errors such as not jumping the number, not adding the sum. so how to handle this problem?

Office information