Removing Wrap Text as the default

[Ditch]

Hi Team,
Is there anyway to set the default such that data/text longer than the cell
width doesn't automatically wrap it?
I know how to activate and deactivate wrap text but it is annoying that the
default when pasting data is to wrap text.
I handle large spreadsheets with +3,000 records and having to disable wrap
text everytime new data is populated to the sheet is annoying. I use a a
separate sheet to view the data where I wrap all text in apppropriately sized
cells there.
ta, Ditch

 

[Roady [MVP]]

Wrong newsgroup?
Sounds like you need to ask this in an Excel newsgroup instead.
Note that this is an end-user to end-user newsgroup. Microsoft does not
actively participate here.