as the title says, I have xfd number of columns, and nothing I do can get rid of them. I cannot add the excel doc here, as it contains sensitive info, and I apologize for that. I have tried everything I can, and no matter what, the xfd column remains there. I cleared all formatting, cleared all data, deleted, saved, reloaded, etc. to no avail. I would add data to 2 random columns, and then delete the columns between them. the data would then show as being next to each other, meaning all columns in between were successfully deleted, but column xfd was still there, mocking me.
I have begun to have nightmares of all the empty columns. please send help.
XFD
column. As stated by @FlexYourData the only method to not "SEE" the columns is to hide them. The columns still exist just are not visible.