How to draw a table in Excel? (With editing and filtering them)

In this article, we will teach you how to create a spreadsheet in Excel. You can use this on both Windows and Mac operating systems.

Part 1: Creating a table

1. Open an Excel document. To open the existing document, you can double-click on the document itself or right-click on the document and select Open. Or open Excel, then find the document from the main page.

  • You can also click on the Blank Workbook option in the Excel home page to create a new document . Next you need to enter your data.

2. Select the table data. To select the data range, first click on the first cell at the top-left of the range, then hold down the Shift key و and simultaneously click on the last cell at the bottom right to select the range.

  • For example: If the data is in the range of columns A to D and rows 1 to 12 , first select cell A1 and while holding down the کلید shift key , click on cell D12 to move cells in this range. Be selected ..

3- Click on the Insert tab. By clicking on the Insert tab in the green ribbon bar above, the tools and sections of the tab are displayed.

  • If you are using a Mac operating system, be sure not to click the Insert menu in the Mac menu bar.

4- Click on the Table option. This option is located in the “Tables” section. Clicking on it opens a window to create the table.

5- OK. Click on this button to create a table.

  • If you also select the top row of the range containing the column headings , check “My table has headers” before clicking the OK button .

Part 2: Changing the table design

1. Click on the Design tab. Click the Design tab from the ribbon bar to display tools and options related to table design.

  • If you do not see this tab, click on the table to activate it quickly.

2. Choose a design for the table. Click on one of the color schemes in the “Table Styles” section to apply its color and design to the table.

  • Click on the down arrow to the right of the colored boxes to see more designs.

3- Review other design options. In the “Table Style Options” section, you can enable or disable any of the following options and boxes:

  • Header Row – Adds to the header table. It actually places a row for column headings at the top of the data set. Uncheck this box to delete these titles.
  • Total Row – If enabled, adds a row at the bottom of the table that shows the sum of the values ​​of the first column on the right.
  • Banded Rows – Check this box to color the rows of the table one by one, and if you uncheck it, the rows of the table will be displayed in the same color as before.
  • First Column and Last Column – Enabling these options will highlight the first or last column.
  • Banded Columns – This option colors the columns one by one, and if you uncheck it, the table columns will retain the same color as before.
  • Filter Button – Enabling this box adds a drop-down list next to the title of each column in the table that you can change the way the data is displayed in that column.

4- Click on the Home tab. Return to the Home tab on the ribbon. Changes made to the table will be saved.

Part 3: Filter table data

1. Open the filter menu. Click the arrow next to the title of the column whose data you want to filter. A drop-down list will be displayed.

  • To apply the filter, the “Header Row” and “Filter Button” boxes must be enabled in the “Table Style Options” section of the Design tab .

2. Select a filter. You will see the following options in the menu:

  • Sort Smallest to Largest sorts data from small to large.
  • Sort Largest to Smallest Sorts data from large to small.
  • Depending on the data, you can use other options such as Sort by Color or Number Filters . Just click on it to apply the filter to the data.

3- Filter the data display. Depending on the desired filter, you may select a specific range or type of data. Then select the data you want to display and click OK.


Leave a Reply

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