In this post we will show you how you can combine or join cells in ExcelEither by keyboard shortcuts or by using a simple button in Microsoft Excel.
Microsoft Excel is the most advanced and complete calculation program available, which belongs to the Microsoft Office package.
Thanks to this program, we can carry out financial and strategic processes, mainly from our businesses or inventories, using basic processes such as adding, subtracting, multiplying and dividing, or more advanced processes, such as formulas.
Excel makes this work much easier with its interface and easy basic use of cells, however, at any given time, we should know how to combine and join two or more cells.
Join us throughout this article, where we will teach you step by step how to merge cells in Excel and maintain a more complete and clean document.
Steps to combine cells in Excel
If you are in a task where you need to append or combine cells to keep a more orderly document, you can apply this process.
We must tell you that there are different ways of doing the process, and here we will list two of the easiest and fastest ways to do it and don't waste time. So, let's see how to do it!
By means of the option «Combine and Center»
There is a button in Microsoft Excel that perform the entire procedure without having to use formulas or keyboard shortcuts, and it is the option of «Merge and center».
Thanks to this button, we can combine cells in Excel to our liking. They can be two, three, square or whatever you want, both vertical and horizontal.
Follow these steps to combine cells in Excel using the "Merge and center" option:
1 First, select cells you want to combine in Excel.
2.- Later, go to the tab «Home», and locate the "Alignment" tool group.
3.- After that, locate the icon of the "Merge and center" option, as we show you here below:
As you can see, you will have several options:
- Merge and center: It combines the cells you select and also centers the text or content that is within those cells.
- Combine horizontally: combines cells horizontally, as well as their content.
- Separate cells: undoes the combination of cells and separates them.
- Merge cells: it just merges cells without centering the content.
4.- Once you press the option, you will be able to combine the Excel cells that you selected and see the result.
By using keyboard shortcuts
Microsoft Excel has incorporated keyboard shortcuts for quite some time, and thanks to them, we can access different options without moving the mouse so much or mouse.
In the case of using this tool, we will use the same option "Combine and center" to unite the cells without losing the data it has inside.
Follow these steps to be able to combine and join cells in Microsoft Excel by using keyboard shortcuts:
1 First, press the ALT key to access keyboard shortcut options. You will see that on the side of the options, you will have letters and numbers, as you can see here:
2.- These numbers and letters indicate your keyboard shortcut, and, to access the sections, you must press said key. As you can see in the image above, you must press the «O» key to access «Home»; That's where you can find the option to "Merge and center" cells.
3.- Once you are in the «Home» section, you must press the letter «M» followed by the number «2» to access the "Combine and center" option, as you can see here:
4.- When you press that set of keys, the section menu will be displayed. Next, press the «C» key (Not without first selecting the cells you want to combine). Ready!
We hope this tutorial has been helpful for you. Do not forget that in this blog we write more than the Microsoft Office parcel. Visit us!
See you until a new post, reader.