Excel is a widespread program,allowing you to automate routine work, accumulate and organize data in the form of tables with the ability to enter formulas and the subsequent automatic calculation of the results. Spreadsheets are used not only for accounting and reporting purposes. They are gaining popularity in almost all spheres of activity. This is primarily due to the functionality and usability of the program, since Excel allows you to present the accumulated information in the form of tables and diagrams. To successfully create large and meaningful databases, the user needs to know how to merge cells in Excel. Graphical representation of data is very convenient for perception, visual display of information and its presentation, as well as for analysis of available data.
Due to the abundance of functions of the program, beginnersusers encounter different difficulties. When creating complex tables, it becomes necessary to group the data. In this connection, at the initial stage of creating a table, the question arises: "How to combine cells in excel?". It's very easy to do this. Let's describe the process of combining cells:
2. Next, move the mouse cursor over the selected cell area. Press the right mouse button, a pop-up menu appears. In the resulting list, select the "Format cells".
3.A detailed window with several bookmarks opens. We need to open the second tab "Alignment". Then in the "Display" section we select the item "Merging cells", click "OK". Now we see that the cells selected by us have merged into one. The table below shows how the merged cells can look:
| Name | Price | |
| rub. | $ | |
Knowing how to merge cells in Excel, you canadjust other indicators - format, font size and type, text layout and indents, text direction in the cell. You can also make their boundaries, that is, choose the necessary thickness, shape and color of the lines. The "Number" tab allows you to set the required format of data representation in the form of ordinary numbers or text. The monetary format is convenient for calculations, because it highlights the negative values obtained in red font. Formats "Date" and "Time" contain several options, it remains only to choose the most convenient.
| № п / п | Name | Value, thous. rub. | Share,% | Deviation, (+/-) 2006-2007. | |||||
| 2005 | 2006 | 2007 | 2005 | 2006 | 2007 | thousand roubles. | % | ||
| 1 | Intangible assets | 35 | 23 | 12 | 0,01 | 0,01 | 0,004 | -11 | -47,83 |
| 2 | Fixed assets | 302030 | 268665 | 253577 | 48,94 | 78,78 | 78,99 | -15088 | -5,62 |
| 3 | Construction in progress | 11708 | 11700 | 11710 | 1,90 | 3,43 | 3,65 | 10 | 0,09 |
| 4 | Profitable investments in tangible assets | ||||||||
| 5 | Long-term financial investments | 14370 | 14388 | 14338 | 2,33 | 4,22 | 4,47 | -50 | -0,35 |
| 6 | Deferred tax assets | 289005 | 46274 | 41378 | 46,83 | 13,57 | 12,89 | -4896 | -10,58 |
| 7 | Other | ||||||||
| TOTAL out-of-turn. assets | 617148 | 341050 | 321015 | 100,00 | 100,00 | 100,00 | -20035 | -5,87 | |
The need to merge cells in excel arisesusers mostly in the creation of a header, when the table contains a large amount of data. For convenience of perception, more visual presentation of data, as well as for faster and more convenient information retrieval, you can also use the fill function. You can do this directly from the control panel using the Fill button, or select the desired color from the drop-down list. As you can see, Excel is very convenient, because it allows you to customize the kind of displayed data individually, according to the needs of a particular user. We hope that in the future the question of how to merge cells in Excel will not put you at a deadlock.
