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 keep ?
Thanks
1 Reply
Sort By
- Patrick2788Silver ContributorYou 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