【Make a Table in Excel】Step by Step Guide ▷ 2022

Currently, It is considered the most important office program for perform accounting, financial, organizational and scheduling tasks. Because, consists of an arrangement of divided by boxes that make it easy to create, modify, and manage spreadsheets.

Thanks to this characteristic, it is an ideal software for tabulate and organize any type of information effectivelyAs for insert data in order to interpret and store it for study. In addition, it provides numerous functions and tools to be able to work with numerical data and make calculations using mathematical utilities.

And if that was not enough, provides options dedicated to managing tables. Which means that, within this program, users have the ability to create a table within a spreadsheet in order to keep any data flow organized and present it in a better way. For this reason, we will explain to you below how to create and customize a table in excel.

Learn how to create a table in your Microsoft Excel spreadsheets

While it is true, create and use tables in Excel spreadsheetsit is completely useful for the users who manage this program of Microsoft. Since, in addition to being elements that facilitate the organization of information on a large scale.

They also allow you to sort data in a simple way., change the style and colors according to the person’s tastes, add or remove rows and columns, as well as filter data. But, to be able to do all this, first of all, it is essential to know how to create a table inside a Microsoft Excel document, correctly.

Therefore, we proceed to explain each and every one of the steps to follow to carry out said action:

• To start, you have to access the Excel file in which you want to create your new table or, failing that, in the blank spreadsheet to use for it.
• After that, with the mouse cursor located in the cell from where you want to create your table, go to the options bar of the program and click on the “Insert” tab.
• Next, in the options available in that tab, search and select the one that says “Table”.

• done the above, a small box will be displayed which displays the selected range among the existing cells, to create the table in question. Therefore, you must slide the mouse in order to cover the total number of rows and columns you want your new table to contain.

• Once you have made the choice indicated above, you only have to click on the “OK” button in the corresponding box. With this, your complete table will be displayed immediately in Excel so that you can enter the data you need in it.

• Additionally, you have the possibility of customize table style. This, from the tab “Table Tools > Layout” and there, just click on the box “Table Styles” to choose the one you like the most.

Master Excel Tables Learn how to fully customize Excel tables!

Beyond modifying the style of the tables that you create in MS ExcelYou also have other additional options of great interest to fully customize these elements.

That is why, in this section of the post, we will teach you how to sort data within a table, how to add or delete rows and columns, as well as how to filter data correctly:

computer data

Through this utility, it is possible to rearrange the data in order to find values ​​more quickly or, failing that, to prescribe the information in alphabetical order or by color (if possible). Assessing that, it is an effect that occurs depending on each column of data.

Here’s how to do it:

• Initially, search for the Excel document and the table to organize through the function provided by the program.
• Next, locate the column you want to rearrange and click the down arrow which is located in the first cell of it.
• Now, among the available options, you can choose between “Sort A to Z”, “Sort Z to A” or “Sort by color”.
• Once you select any of the above options, you will observe the change that will be made within the table in question and around all the added data, correspondingly.

On the other hand, this procedure can also be carried out directly from the “Startup” tab of the options bar. There, you have to look for the Modify group and then click on “Sort and filter” in order to be able to choose any of the options mentioned in the previous process.

Add or remove rows and columns

For many users, it is also necessary to know how to add new rows or columns inside an excel table as well as delete some of them.

In this case, the steps to follow are also very simple and, below, we specify each of them:

• For add an additional row or column, go to the cell from which you want to add any of these elements. So, right click there and right away, Select the “Insert” option. Then press on “Table columns to the left” to add a new column or click on “Table Rows Up” to be able to enter a new row.

• On the contrary, if you want override a row or column of your table, you have to locate yourself in the cell to be deleted and right click on it. Subsequently, Click on “Delete” and among the options that are shown, choose if you prefer delete the entire column in question or the rows located in that order.

It should be noted that, to delete the information contained in any row or column, you can also do it using your computer’s mouse and keyboard. Since, just by choosing the entire row or column by sliding the mouse cursor and pressing the “Delete” keythe data in that array will be erased.

Filter data in a table

Via Excel, you can also filter the information in a table in a spreadsheet. Either for find values ​​quickly, control what you want to see at a time or data, and even to exclude certain data momentarily. Whereas, you can filter values based on the choices you make from a list or by creating specific filters.

To do this, the steps to follow are:

• Once you locate the table to filter in this way, you have to proceed to search for the column to which you want to apply the filter (either text or by color).
• Next, click on the down arrow that contains the column of the table in question and select the type of filtering you want to apply to it. In this case, we will choose “Text filters”.

• Next, choose one of the available parameters, in order to filter the information according to that aspect. Here, select “Starts with” and, immediately, the indicated box will be displayed to assign there the data from which you prefer to filter the content of the table.

• Now, click on the “OK” button and automatically, the values ​​that match the applied filter, only and exclusively, will be displayed.