Excel: Connect cells and columns

In this practical tip, we will show you how to combine several cells and / or columns into one in Microsoft Excel - for example, to get more space for a heading.

Connect cells and columns in Excel

Microsoft Excel still represents the top dog in spreadsheets. To connect individual fields, proceed as follows:

1. Mark the desired area with the mouse. If you want to merge complete rows or columns, hold down the "Ctrl" key and click on the corresponding letter or number at the top or left edge of the screen.
2. Now look for the icon in your toolbar to connect: It is a small box with arrows to the left and right and a small "a" in the middle. Click on it.
3. You have already connected the marked area to a large field.

In the next practical tip, you will read how to display two tables side by side in Excel.