A table of information is created in Microsoft excel.You can do this on both Windows and Mac.
Step 1: You can open your excel document.
Select the document's name from the home page if you double click the excel document.You can open a new document by clicking on the home page, but you have to input your data first.
Step 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 the Shift key.If you have data in cells that are down to and over, you would click and hold Shift.
Step 3: Click on the insert tab.
There is a tab in the green ribbon.Below the green ribbon, the toolbar will be displayed.Don't click the menu item in your Mac's menu bar if you're on a Mac.
Step 4: Click the table.
There is an option in the "Tables" section.There is a pop-up window when you click it.
Step 5: Click OK.
It is at the bottom of the window.It will create your table.If your data group has cells at the top of it that are dedicated to column names, click the "My table has headers" option before you click.
Step 6: You can click on the design tab.
There is a green ribbon near the top of the window.The table's design can be opened directly below the green ribbon.Click your table to see this tab if you don't see it.
Step 7: Pick a design scheme.
To apply the color and design to your table, click on one of the colored boxes in the "Table Styles" section.To scroll through different design options, you can click the downward-facing arrow to the right of the colored boxes.
Step 8: Take a look at the other design options.
In the "Table Style Options" section, check or uncheck any of the following boxes.If you check this box, you can remove the headers.This option adds a row at the bottom of the table that displays the total value of a column.You can either color in alternating rows or leave all rows in the same color.The options make the data in the first and last columns bold.If you want to change the color of the columns in your table, check this box.This box allows you to change the data displayed in a column by placing a drop-down box next to it.
Step 9: Click the Home tab again.
This will take you to the website.The table's changes will remain.
Step 10: You can open the filter menu.
The column whose data you want to filter has a drop-down arrow to the right of it.A menu will appear.The "Filter" and "Header Row" boxes must be checked in the "Table Style Options" section of the tab in order to do this.
Step 11: You can choose a filter.
You may have additional options such as or depending on your data, if you click one of the following options.If you choose one of these options, you can click on a filter in the pop-out menu.
Step 12: Click OK if prompted.
You may have to choose between a range or a different type of data before you can continue.The filter will be applied to the table.