Actually, Excel It is considered the most important office software for perform accounting, financial, organizational and programming tasks. Because, consists of an arrangement of rows and columns divided by boxes that facilitate the creation, modification and management of spreadsheets.
Thanks to this feature, it is an ideal software for tabulate and organize any type of information effectively, As for insert data 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 dedicated table management options. Which means that, within this program, users have the possibility to create a table within a spreadsheet in order to keep any data stream organized and present it in a better way. Therefore, below, we explain how to build 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 spreadsheets, it is completely useful for the users who manage this program Microsoft. Since, in addition to being elements that facilitate the organization of information on a large scale.
They also allow to order data in a simple way, change the style and colors according to the tastes of the person, add or remove rows and columns, as well as filter data. But, in order to do all of 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, on the blank spreadsheet to be used for it.
- After that, with the mouse cursor located in the cell from where you want to create your table, go to the program's options bar and click on the “Insert” tab.
- Then, in the options available in that tab, search and select the one that says "Table".
- Having done the above, a small box will be displayed that shows the selected range among the existing cells, to create the table in question. So, you must slide the mouse in order to fill the total number of rows and columns you want your new table to contain.
- Once you have made the choice indicated above, you should only click on the "OK" button in the corresponding box. With this, immediately, your complete table will be shown in Excel so, enter the data you need in it.
- Additionally, you have the possibility of customize table style. This, from the tab "Table Tools> Design" 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 you make in Microsoft Excel, you also have other additional options of great interest to fully customize these elements.
That is why, in this post section, we will teach you how to order 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, data can be rearranged in order to find values more quickly or, failing that, to prescribe information in alphabetical order or by color (if possible). Valuing that, it is an effect that occurs depending on each column of data.
Next, we indicate how to carry it out:
- Initially, Find the Excel document and the table to organize through the function provided by the program.
- Then locate the column you want to rearrange and click the down arrow found in the first cell of it.
- Now, among the available options, you can choose between "Sort from A to Z", "Sort from Z to A" or "Sort by color".
- Once you select any of the previous options, you will see the change that will be made within the table in question and around all the added data, correspondingly.
For its part, this procedure can also be carried out directly from the "Start" tab of the options bar. There, you have to search for the group Modify and then click on “Sort and filter” in order to choose one 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, like delete some of them.
In this case, the steps to follow are also very simple, and then we specify each one 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 click on “Columns of the table on the left” to add a new column or click on "Rows of the table above" to be able to enter a new row.
- On the contrary, if you want override a row or column in your table, you have to go to the cell to delete and right click on it. Later, click on "Delete" and among the options displayed, choose if you prefer delete all column in question or rows located in that order.
It should be noted that, to delete the information contained in any row or column, you can also carry it out using the mouse and keyboard of your computer. Since, just choose the entire row or column by sliding the mouse cursor and pressing the "Del" key, the data of said arrangement will be erased.
Filter data in a table
Through ExcelYou can also filter the information from a table in a spreadsheet. Either for find values quickly, control what you want to see in a moment 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.
For this, the steps to follow are:
- Once you locate the table to filter in this way, you have to proceed to find the column to which you want to apply filtering (either text or color).
- Then click the down arrow that contains the column of the table in question and select the type of filtering you want to apply. In this case, we will choose “Text Filters”.
- Next, choose one of the available parameters, in order to filter the information according to this aspect. Here, select "Start 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 the "OK" button and automatically, the values that match the applied filter will be displayed, solely and exclusively.
