In fact, the entire Excel software package is one large table, with countless columns and cells. However, this does not mean that the user cannot create its own. About them, as well as useful tricks when working with Microsoft Excel, we will talk below.
How to use tables Excel?
So, in order to turn the open list of the program in a full-fledged table, you just need to sort the data and start making them into the cells. The latter are numbered, divided into columns and cells for the convenience of navigation, works of mathematical computing, analysis, other useful functions. Here are some Excel Tips, which will help in handling it:
- to separate the desired number of cells with information from the rest of the space, use the "border" button on the toolbar or find the item of the same name in the "Main" menu -\u003e "Font" (using the field drop-down interface, you can manually draw or choose from the proposed layouts, do not forget Pre-highlight the desired cell field using the mouse cursor);
- additional design will also help to give the table a more completed view: Circle headings with color or underlines, having studied the program panel marked in the illustration;
- if the table assumes the presence of complex calculations, use the formula check function (for example, to remove the error # value!): Select a problem cell, go to the "Formulas" menu -\u003e "dependencies", select the capabilities of the dependent cells, the error source or other necessary data ;
- use the "Home" tab partitions: Subsection "Number" will allow you to specify the chemut for your information, including the number of numbers after the comma;
- the "Styles" subsection of the same section has a no less convenient function, for example, the ability to paint the cells in different colors, depending on the observance of the specified conditions;
- on the table, it is easy to navigate through the "Find" + buttons to find and replace "if some parameter has changed.
Creating an Excel table through the "Insert" menu
To make a kind of "table in the table", add columns or strings to your calculations, graphic material, characters, or complex functions, Excel offers a wide functionality of the Insert menu. For example, if you need to combine the results from several tables and arrange them on one sheet, you can submit a table as a list, or vice versa. For the information of multiple tables in one, we do the following:
- first, we place on the toolbar, a convenient button "Summary tables and diagrams" button (click on the shortcut panel -\u003e "Other commands");
- if the source table on another sheet - go to it;
- we click on the "Master" button, in the window set "several consolidation ranges" + "Summary Table" and "Next";
- the "Create Page Fields" window appears, also click "Next";
- allocate all table cells to create a data range;
- immediately, the "Add" button, add other tables that need to be taken into account in the final;
- in the next window, alternately allocate the ranges of tables and set the daws at the first, second and subsequent paragraphs (depending on the number of tables), which are fields of the final table;
- after pressing the "Next" button, you specify where to place the result of the information (for example, "new sheet").
The consolidated table from paragraph 2 will be associated with all the starting materials. If the data changes in them, you can update them by finding the appropriate item in the context menu.
0
501
