Select the whole sheet by clicking in the top left intersection of the row and column heading area. Then select "format columns unhide" and format column autofit. Aldo make sure that they slider at the bottom right is all the way to the left (in case the sheet has just scrolled to the right).
_________________________
Andrew Bates