up one level
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://investorworker.com/2015/... .html.]