Removing Wrap Text as the default

  • Thread starter Thread starter Ditch
  • Start date Start date
D

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
 
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.
 
Back
Top