Forum Discussion
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
- 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
