Forum Discussion
FrancineFelske
Nov 07, 2022Copper Contributor
Remove empty columns caused by unmerged cells
I have a sheet with a lot of merged cells. After I unmerged that cells , I am left with numerous empty columns in between the remaining data. Is this a quick way to remove the empty columns. Please k...
Patrick2788
Nov 07, 2022Silver Contributor
You could use Go to Special.
1. Select the affected area
2. F5 to open Go to menu, select special
3. Select 'Blanks'.
4. Right click the selection - delete - entire column
1. Select the affected area
2. F5 to open Go to menu, select special
3. Select 'Blanks'.
4. Right click the selection - delete - entire column