How to Combine Contents of Two Rows of Cells in Excel 2007


When entering data into a Microsoft Office Excel 2007 spreadsheet, you can manipulate and edit the cells so that their appearance meets your preferences. For example, if you have two rows of cells that contain data, you can combine the contents of the cells using the "Merge" feature to ensure that the contents are merged and centered together in one larger cell.

  • Click the "Start" button from the desktop on your computer, and then click the "All Programs" option. Select the "Microsoft Excel 2007" application from the list of programs.

  • Click the "Microsoft Office" button from the top right corner of the program followed by the "Open" option. Select the Excel 2007 worksheet file you want to combine cells with, and then click the "Open" button.

  • Select the two rows of cells that you want to combine with your mouse. The cells should be highlighted.

  • Select the "Home" tab, and then click the "Merge and Center" option from the "Alignment" group. The cells will then be merged together.

  • Click the "Merge and Center" button again at any time to split the merged cells if you no longer want the contents to be combined.

Related Searches


Promoted By Zergnet


You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!