How to Merge Cells in Excel 2013

Spreadsheets that are created in Microsoft’s Excel 2013 are done so for a number of different reasons, many of which cannot conform to the existing default spreadsheet layout. If you are creating an invoice or some other type of document that will require multiple headings and sections, then you will probably need to adjust the layout to make the document look good. Excel’s ability to merge cells is usually a helpful option in this scenario, and it can be accomplished with just a few clicks. So follow the steps outlined below to learn how to merge cells in Excel 2013.

If you know that you are going to be doing a lot of your holiday shopping online, then an Amazon Prime membership can really save you some money. You get free two-day shipping on items shipped by Amazon, plus you will have access to their Netflix-like collection of streaming videos. Sign up for a free trial of Amazon Prime to see if it is right for you.

 

Merging Cells in Microsoft Excel 2013

Note that cell merging is best done before you have entered data into the cells, as Excel will only keep the top-left cell data if you attempt to merge cells that already contain data. If you need to merge cells that already contain data, then it is a good idea to copy and paste that data to other cells on the spreadsheet, then move the data back after you have merged the cells.

 

Step 1: Open your spreadsheet in Excel 2013.

 

Step 2: Click the Home tab at the top of the window.

click the Home tab

 

 

Step 3: Use your mouse to highlight the cells that you want to merge.

select the cells you want to merge

 

 

Step 4: Click the arrow to the right of Merge & Center in the Alignment section of the ribbon at the top of the window, then select the Merge Cells option.

how to merge cells in Excel 2013

 

 

Note that there are several other merge options as well, so you can select one of those instead if it is more appropriate.

If you’ve been looking for a tablet that will also allow you to work on Microsoft Office documents, then check out the Microsoft Surface by clicking the link below.

 

We have previously written about how to combine columns in Excel 2010, which may be more along the lines of what some people are trying to accomplish with their cell merge.