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 adding, multiplying, dividing and subtracting. This type of table design is composed of rows, columns and cells, each of the latter is the intersection of the other two. They may contain text, numbers or a formula that uses existing values ​​in others. In particular they are very practical since not only do they help with these procedures, but they also facilitate the creation of graphs, generate 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 will allow you to keep 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 without mishaps with the function called “concatenate” and other methods which are precisely to unify the contents for better viewing.
If you do not know how to merge in Excel, in this article we will explain step by step what you must do so that your document is in order and as you wish without losing anything.
Table Of Contents
Steps to combine cells in Excel without losing information
If you find yourself doing 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 some writing in the process, you only have to press ” Ctrl + Z ” and you can re-establish.
From the toolbar
With the option of Excel tools you can perform the union of cells to create a larger one. This is if you want to set a label that covers several columns at the same time 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 until you want the label you are creating to arrive.
- Then you will click on the Excel bar, followed by “Start” and you will see where it says “Merge and center”. Pressing there will join the cells automatically.
- If you get to 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 cell has information, 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 in the following way, you just have to follow the respective commands:
- Select the cells you want to merge.
- Then press “Alt” on the keyboard to access the options bar. You will notice that each section will have assigned a letter. To access these you only have to press the corresponding one.
- In this case you will choose the “letter O” since the command you want is on the “Start”tab.
- The combination is assigned to the M2 key, for this you must press on your keyboard the letter M followed by the number 2 to activate the menu.
- When you open it, you will see that each option has another letter set. To execute the command “Merge and center”, you just have to press the “C”.
- This way you will have your columns merged.
Must See: how to make a book in minecraft
From the Tool Bar to Column Configuration
Another way to access this configuration is through the toolbar that gathers most of the program’s commands. To execute it do the following:
- Select the cells you want to join.
- In the “Start” menu you will find the section that says “Format” followed by “Section of cells”.
- Immediately a configuration box will open, where you must search and enter the “Alignment” section.
- In the text control part you will select “Adjust text” “Merge cells” and accept.
- So the cells chosen will be unified and you can make a header or a table of information, according to what you want to do.
Also Check: How to download instagram video
How to combine text from two or more cells in a single cell in Excel?
If you need the text to be complete and it is not separated by columns, with these simple steps based on formulas, you can unify names and figures so that you have a completely legible document without divisions.
Concatenar Formula
- The first thing you have to do is select the cell where you want to place the combined data.
- In the column that you chose, you will write the following formula = CONCATENATE.
- You must use the letter and number of the cells to choose them or click each one with the mouse to identify the ones you wish to unify.
- When selecting them you will be placing (;) between each of them in this way: = CONCATENATE (A1, etc …)
- Having finished choosing the cells you close the parentheses 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 be.
- In the ones you chose so that all the others are joined, you are going to write the following formula “=” and choose the first cell you want to unify, that is = C1 & “
- Select the other cell and give it in “Enter” example “& D1
- Thus in this case, depending on the quantity, the final formula would be: = C1 & “” & D1 & “” & E1 & “” & F1.
- All you have to do is touch the “Enter” key and you’re done.
With this same formula you can also unify the cells, add a text. To do this you must add some writing between the quotes, 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 the functions that have to do with formulas.