Prev: report by date from a list of records
Next: link only cells with a certain colour
From: Staceyglow on 3 Mar 2010 12:01
It appears that when one cuts and pastes from one Excel spreadsheet to
another, it automatically assumes that you want to wrap text if the column is
too narrow. Since I almost never want that, I have to go into the "format
cells" area and uncheck "wrap text" every time.

Is there any way to change the default treatment from "wrap text"?
From: PlutoNash on 3 Mar 2010 12:23
Does the copied cell have 'wrap text' set?

Have you tried 'Paste Special'?



"Staceyglow" wrote:

> It appears that when one cuts and pastes from one Excel spreadsheet to
> another, it automatically assumes that you want to wrap text if the column is
> too narrow. Since I almost never want that, I have to go into the "format
> cells" area and uncheck "wrap text" every time.
>
> Is there any way to change the default treatment from "wrap text"?
From: Staceyglow on 4 Mar 2010 13:10
No, the neither one had 'wrap text' set.

And I didn't try paste special, but I am sure that will work. Should've
thought of that on my own. THanks

"PlutoNash" wrote:

> Does the copied cell have 'wrap text' set?
>
> Have you tried 'Paste Special'?
>
>
>
> "Staceyglow" wrote:
>
> > It appears that when one cuts and pastes from one Excel spreadsheet to
> > another, it automatically assumes that you want to wrap text if the column is
> > too narrow. Since I almost never want that, I have to go into the "format
> > cells" area and uncheck "wrap text" every time.
> >
> > Is there any way to change the default treatment from "wrap text"?
 | 
Pages: 1
Prev: report by date from a list of records
Next: link only cells with a certain colour