follow me on facebook follow me on twitter Instagram

Merge and Center: Excel 2013

I use this in 99% of the spreadsheets I create.
I use it to center the heading/title over the columns that contain data in the spreadsheet

This Merges selected cells together into one cell and centers the text within the new merged cell.

1. Enter the headings and layout of the spreadsheet. Click on the first cell to be merged














2. Type the heading in the first cell













3. Select that cell plus the ones across the row to the end of the data.






4. Click on Home Tab  In the Alignment section click on Merge & Center.







5. The text in the first cell is now centered over top of the spreadsheet data.



No comments:

Post a Comment