Expansion of a format on new cells

[Alexander VS]

Hello all!
The trouble is:
A inexperienced user selected whole rows while formatting
cells (by clicking on rows headers). So some format
attributes extended on everything cell in this rows.
When I delete a column, a new column inserted by Excel in
the right of the sheet inherits format. Even i clear
utmost columns of the sheet.

How can I force Excel to insert clear column when deleting
ones.
PS: I know, that i can select whole row and remove all
format, but there are some troubles: a) there are a lot of
rows on the sheet, b) I need reset formatting after this
operation.
Is there other method?
Thenks.

 

[BrianB]

Train the user so they know what to do ??


Regards
BrianB
=====================================

 

[Alexander VS]

It's a great idea! But there is existing huge file. And
i need to fix this problem with the file.
I found following decision:
1) Select and copy whole worksheet.
2) Paste formats only (Edit\Paste special) on a new
worksheet.
3) Select all and clear formats on first worksheet.
4) Paste format back only into engaged region, with tables.

PS: I think this effect is very odd, when Excel insert new
cells already with format, although i clear last cells.

PPS: Sorry for my English.