I have an Excel spreadsheet that contains names. addresses and various other information. I have word wrap set for all cells in case some new data gets entered that's long. If I sort the data, the data that was in the cells that were word wrapped will end up in cells not word wrapped. In other words the cells formatting as far as word wrap goes does not go with it, or Excel doesn't recognize that it needs to be wrapped. I'm not sure if this is a real problem or a normal function of Excel. I have to highlight the whole sheet and deselect and reselect word wrap to get it wrapped each time I sort it. Any ideas?
Thanks.