Removing Wrap Text as the default

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
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixing text wrap in merged cells 1
Disable automatic text wrap? 2
disabling word wrap in wide plain text messages 2
How to Wrap Text 2
Wrap text in cell 1
Word wrap and height 1
Why does my text in a cell with wrap text and auto height get cut 4
Setting a Default Text Wrap around a Picture in Word 2007 1

Top