If we have used Excel at least once, we will certainly know that this program is very useful for performing calculations on a large amount of data, just enter the values in the various cells and take advantage of the mathematical formulas provided to immediately obtain the necessary calculations. But, if you are a beginner with this important program of the Office suite, you will surely have realized that inserting the numbers in the cells without any type of graphic embellishment risks making reading data dispersive, without making the results or data leap to the eye that we want to show.
For this we have created a guide in which we will show you how to make a table on Excel, so as to put in order all the numbers placed in scattered order on the spreadsheet and insert a graphic element of sure impact.
READ ALSO -> Access or Excel "> To make the future table even more precise, we immediately insert the titles to the various columns and rows, so that they are already correctly inserted into the table that we are going to create. An example of how enter the "ready" data we can see it in the image below.
Obviously this is only an example, but we can copy this scheme without problems, which is also among the most used. In addition to the columns, we can also insert the titles of the various rows, so as to meet any requirement with the spreadsheet.
Once all the necessary data have been entered, select everything with the mouse, keeping the first box at the top left ( Enter in our case) pressed down to the last cell in which there is a data, at the bottom right ( 369 in our case) .
We will immediately see a small icon at the bottom right of the selection, as visible in the image below.
The program has already recognized the table layout and is advising us to create a quick table!
Click on the icon and go to the Tables field, so that we can select the one that suits us best.
Once we find the table, we click on it to see it appear in the same cells where we entered the data.
You may not like the default style: in this case just go to the Design menu at the top and click on the item Quick Styles, so you can quickly change the style and colors of the table.
Alternatively we can add a table by clicking on the Insert menu at the top and then clicking on one of the buttons associated with the creation of the tables, namely Pivot Table, Recommended Pivot Tables and Table .
Alternatively we can also go to the Home menu and click on the Format as table item .
If after creating the table we want to add more data to it, we will not have to repeat all the steps already seen previously; to add a new row or column, simply move the mouse to the lower right corner of the table and, keeping the left button pressed, drag downwards or to the side to "enlarge" the table.
Once the table has been enlarged, just insert the new data into the additional cells to be able to immediately integrate them with the other data also from a graphic point of view.
We want to add a row on the fly with all the sums of the values inserted in the columns of the table ">
If we want to remove a table created in Excel, all we have to do is select the table and press the DEL key on the keyboard; alternatively we can always use the Delete -> Delete all button, present in the Home menu.
Create a table on Calc (free)
As we can see from the official Office page, we can buy the most used office suite in a monthly or annual subscription or, for the most demanding users, even in a single solution, however, paying a considerable amount (at least € 149).
If we need a spreadsheet with a table immediately and do not want to buy Office, we recommend downloading the free LibreOffice suite on your PC or Mac.
Among the programs included there is also Calc, which offers good management of spreadsheets and allows you to create tables in a very simple and immediate way.
We then open this program and insert the data in the various cells, as already seen on Excel, when ready we select all the cells in which there are data with the mouse, click on the Format menu and finally on Automatic formatting styles .
A new menu window will open where you can choose the style of the table, with various choices in the left column and some items to customize it immediately.
Once we have chosen the right style for our table, we click OK to make the changes effective.
To delete the table just select it, right click with the mouse and choose the Delete direct formatting item.
READ ALSO -> How to make calculations on Excel
