If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
stop changing of format
I want Excel to stop changing my set word wrap funtionality from off to on
when copying or deleting data in a workbook. I will copy data from one sheet to another only to have Excel reset the WordWrap funtion back to on from off causing the cell with the data to get much larger. If I wanted the feature , I would have enabled it. It doesn't happen to every set of data copied, just on occasion. I deleted some data from a row and then it reset the feature from off to on for a set of nearby data. It isn't a problem that causes loss of data, but a nuisance to have to go back and turn it off again. The data copied did not have it turned on in the from location, so it is not like it is changing formats when copied. If there were a way to set it to default of off, that would be the best way to solve this. |
Thread Tools | |
Display Modes | |
|
|