How to merge and center in excel 2013 how to#
Your cell data will now be vertically centered inside of its’ cell.ĭo you only want to print some of the cells in your worksheet, instead of the entire thing? Learn how to print a selection of cells in Microsoft Excel 2013 and reduce the size of your printed document. Step 4: Click the Middle Align button in the Alignment section of the navigational ribbon at the top of the window. Step 3: Click the Home tab at the top of the window. As mentioned previously, you can also select multiple cells, if you wish. Step 2: Click the cell containing the data that you want to center vertically. Step 1: Open your spreadsheet in Excel 2013. You can simply select the cells that you want to modify, instead of only selecting an individual cell in step 2 below. The same method can be applied to multiple cells as well. The steps in this tutorial will show you how to vertically align the data in one cell of your spreadsheet. How to Vertically Center Info in a Cell in Excel 2013 If you click on the OK button, then cell A2 ’s value (upper-left) will be intact and cell B2 ’s value will be discarded. Excel will show you a message like the following one.
This can be especially effective when you are working with cells that have a large row height, as vertically centered data can often print better, and can be easier to read. So, I select cells A2 and B2 and click on the drop-down part of the Merge & Center command and choose Merge & Center command from the list. Our step-by-step instructions below will show you how to vertically center the data within a selected cell. Fortunately Microsoft Excel allows you to specify the vertical alignment of data inside of your worksheet cells. But changes to formatting and row height can force you to make an adjustment. From the Table Tools Layout tab, in the Merge group, select Merge Cells. Select the cells you want to merge (by pressing Shift and clicking). This feature works the same in all modern versions of Microsoft Word: 2010, 2013, and 2016. The text inside of a cell in a Microsoft Excel worksheet is aligned to the bottom of the cell by default. Heres how to merge cells in Excel 2016 these steps should also work in previous versions such as Excel 2013 and Excel 2010. Its easy to merge cells in the tables you add to Microsoft Word documents.