Cleaning formatting after last column

[excelforecasting]

Hi All,

I am cleaning up an file with dispersed formatting all over the place.

I know the following procedure:

1. Saving file as .xlsb file
2. Deleting formatted columns
3. Saving and closing the file

When exercising step 2 I encounter a problem.
My file is large and calculation power is low. So I start at the back end of the file (columns XFD and the ones before).
If I delete these lines, then new formatted lines pop up as new columns.
Also, if I clear the formatting in the last columns and then delete these columns, then new columns that arise include the previous formatting.
In this way I cannot get rid of my formatted cells.

It seems to me as if there is formatting after columns XFD.

I hope anybody can help with getting rid of this unrequired formatting.

Best regards,
S.

 

[AlexandraT]

I can only assume that when the formatting was set up initially, the user selected entire rows and not columns. To delete, you can select the entire sheet, Clear formatting, delete unwanted columns, and reformat the columns you want. Or, select the rows in the columns you want to delete (if, for instance, you want to delete from column D onward, select D1 then select the entire row from there on by simultaneously pressing SHIFT+CTRL+RIGHT ARROW and then select remaining rows in the columns by simultaneously pressing SHIFT+CTRL+DOWN ARROW), Clear formatting and then delete. If you have issue due to calculations, change it to Manual calculations instead of automatic. After deleting, change back to automatic calculation (FORMULAS->Calculation Options). Hope this makes sense.
Alex