How to split a cell horizontally in Google Sheets
By
SpreadCheaters
Page last updated:
19/04/2023 |
Next review date:
19/04/2025
You can watch a video tutorial here.
When formatting tables in Google Sheets, you may need to merge rows to properly label the data and to make it look neater. When rows are merged in Google Sheets, only the data in the top left cell is retained and the data in the other rows are lost. Having merged some rows into a single cell, you may want to ‘unmerge’ the cell or split the merged cell horizontally. Only cells that have been merged can be split.
Step 1 – Select the cell
– Select the cell that is to be split
Step 2 – Navigate to the merge button
– On the ribbon, expand the Select merge type dropdown
Step 3 – Unmerge the cell
– Choose Unmerge
Step 4 – Copy the data
– Copy and paste the data into the new rows
