Ask Your Question

How to split a single cell into 4 cells in calc [closed]

asked 2020-09-29 08:41:45 +0100

Yamraj gravatar image

Version: (x64) OS: Windows 10

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Yamraj
close date 2020-09-30 10:32:14.370716

2 Answers

Sort by » oldest newest most voted

answered 2020-09-29 11:06:46 +0100

keme gravatar image

updated 2020-09-29 11:10:41 +0100

A spreadsheet cell grid is rigidly locked to the row/column coordinates. You can merge a rectangular region of cells to appear as one larger cell, but you cannot have additional cell borders between the row/column borders. this is different from the structure of insertable tables (in e.g. Writer), where you can split and merge cells horizontally and vertically at will (albeit to a limited degree of complexity).

Composite cell content can be split, and distributed to multiple cells as per @igorlius' answer. A single cell cannot be split, except for the restoration of merged blocks. To split a previously merged block, select the merged cell, and then click the Merge tool or one of the menu items in Format - Merge cells

edit flag offensive delete link more

answered 2020-09-29 10:43:14 +0100

igorlius gravatar image


if the text content you want to seperate (has a common delimiter eg. comma, semicolon) you can use Data -> Text to Columns to split the cell

Hope that helps.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2020-09-29 08:41:45 +0100

Seen: 87 times

Last updated: Sep 29 '20