up one level
---
2015-01-23

2̶0̶1̶5̶-̶0̶2̶-̶0̶1̶

In a Spreadsheet How to Merge Cells so Multiple Cells Act Like One Spreadsheet Cell

I’m so excited that I learned how to do this. I learned this by getting a spreadsheet from someone. The spreadsheet had merged cells. I right-clicked in its properties and poked around and saw Merge cells was turned on. I turned it off and saw that the merged cell turned back into individual cells.

MS Excel: select multiple cells -> right-click and choose “format cells” -> alignment tab -> Text control section -> enable “Merge cells” checkbox.

LibreOffice: select multiple cells -> right-click and choose “Merge cells”.

That’s how to, in a spreadsheet, turn multiple spreadsheet cells into one spreadsheet cell.

*2015-03-04 edit: added actual publish date of 2015-01-23 at top
*2015-07-30 edit: fixed whitespace to improve this post’s readability


[2019 edit: Moved to: https://i̶n̶v̶e̶s̶t̶o̶r̶w̶o̶r̶k̶e̶r̶.̶c̶o̶m̶/2015/... .html.]