Excel is a spreadsheet program that includes the Microsoft Office package, a very versatile tool suitable for financial tasks and what this refers to. In them you can perform various mathematical operations such as add, multiply, divide and subtract. This type of table design is composed of rows, columns and cells, each of the latter is the intersection of the other two. They can contain text, numbers or a formula that uses existing values in others. In particular, they are very practical since it not only helps with these procedures, but also facilitates the fact of creating graphs, generating databases, budgets, among other things.
If you want to keep track of your finances, or if you are a merchant and you are starting with your business, Excel is a good idea to get the accounts or generate your inventories, because it contains a kind of boxes where each one goes to allow to maintain an order in the information that you enter. Many times when doing these jobs, there is a need to combine several columns with each other, fortunately you can do it smoothly with the function called “concatenate” and other methods, which are precisely to unify the contents for a better visualization.
If you do not know how to merge into Excel , in this article we will explain step by step what you should do so that your document is in order and how you want it without losing anything.
Index:
Steps to merge cells in Excel without losing information
If you are developing a task in this program and want to improve the appearance of your book and columns, you can apply a combination of cells to have a better understanding and interpretation of the information.
To execute this, you just have to perform the steps as shown below. In case you lose any writing in the process, you just have to press “ Ctrl + Z ” and you can restore.
From the toolbar
With the Excel tools option you can perform the union of cells to create a larger one. This in case you want to set a label that covers several columns at once , as shown in the example below:
To do this you must do the following:
- You will click on the first cell and you will select the rest as far as you want the label you are creating.
- Then you will click on the bar Excel, followed by “Start” and look where it says “Merge and center” . Pressing there will automatically join the cells.
- If you change your mind, you can also undo everything you did either in the same “Combine and center” option or with the “Ctrl + Z.”
- IMPORTANT : Verify that only one of the cells has information, because otherwise you will lose the rest. Since you are in this case combining to create a header.
From the keyboard
If you want to speed up this process by a shortcut, we tell you that you can do it from the keyboard as follows, you just have to follow the respective commands:
- Select the cells you want to merge.
- Then press on the “Alt” keyboard to access the options bar . You will notice that each section will be assigned a letter. To access these you just have to press the corresponding one.
- In this case you will choose the “letter O” , since the command you want is in the “Home”.
- The combination is assigned to the M2 key, to do this you must press on your keyboard the letter M followed by the number 2 to activate the menu.
- Upon opening you will see that each option has another letter set. To execute the “Combine and center” command, just press the “C”.
- This way you will already have your columns merged.
From the toolbar by column configuration
Another way to access this configuration is through the toolbar that gathers most of the commands of the program. To run it do the following:
- Select the cells you want to join.
- In the “Start” menu you will look for the section that says ” Format ” followed by “ Cell section ”.
- Next, a configuration box will open, where you will have to search and enter the section“ Alignment”.
- In the text control section you will select “Fit text” “Merge cells” and accept.
- So the chosen cells will be unified and you can make a header or an information box , according to what you want to do.
How to combine text from two or more cells in a single cell in Excel ?
If you need the text to come out complete and that it is not separated by the columns, with these simple formula-based steps, you can unify names and figures so you have a fully readable document without divisions.
Formula Concatenar
- The first thing you have to do is select the cell where you want to place the combined data.
- In the column you chose you will write the following formula =CONCATENAR(.
- You must use the letter and number of cells to choose them or click each one with the mouse to identify the ones you want to unify.
- By selecting them you will be placing (;) between each of them in this way: = CONCATENATE (A1; etc…
- When you have finished choosing the cells you close the parenthesis and the formula should look something like this: = CONCATENATE (A1; B1; C1; D1) depending on the amount you want.
- Once this is done, you will only have to touch “Enter” and your cells will merge into one.
Formula with &
- You must also choose the cells where you want the result to remain.
- In which you chose to join all the others, you will write the following formula «=» and choose the first cell you want to unify, that is, =C1&g
- Select the other cell and click on «Enter» , example, accounted for & D1
- So on, in this case depending on the quantity the final formula would be: = C1 & »« & D1 & »« & E1 & »« & F1.
- All that remains is to touch the « Enter» key and that’s it.
With this same formula you can also in addition to unifying the cells, add a text. To do this, you must add between the quotes some writing, something similar to this: = C1 & »Name« & D1 & »« & E1 & »« & F1
These steps can be done from the same column or from the «Insert function» (Fx) bar that acts as the Excel assistant for functions that have to do with formulas.
>