Hi Go to excel option, then advance & untick extend data range & format...See attached Image..

auto format cell.jpg