ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wrap Text not working in places (https://www.excelbanter.com/excel-discussion-misc-queries/216617-wrap-text-not-working-places.html)

Nick Wakeham

Wrap Text not working in places
 
I have made up a new spreadsheet in Excel2007. Part of the sheet I have
copied from a Excel2003 spreadsheet and pasted it into the new one.

I have put Wrap Text as format of all cells but only the cells on the
non-pasted parts of the spreadsheet work - the cells on the part I pasted
in, although showing up in Format as having Wrap Text selected, won't wrap -
what am I doing wrong??

Have also checked through Google and all the solutions there, such as merged
cells, etc don't have any bearing on what I am doing as the cells haven't
been merged.

Nick



Kevin B

Wrap Text not working in places
 
Verify that the cell where WRAP TEXT is not working are not merged cells. If
the cells are merged the text will not wrap.

Hope this helps...
--
Kevin Backmann


"Nick Wakeham" wrote:

I have made up a new spreadsheet in Excel2007. Part of the sheet I have
copied from a Excel2003 spreadsheet and pasted it into the new one.

I have put Wrap Text as format of all cells but only the cells on the
non-pasted parts of the spreadsheet work - the cells on the part I pasted
in, although showing up in Format as having Wrap Text selected, won't wrap -
what am I doing wrong??

Have also checked through Google and all the solutions there, such as merged
cells, etc don't have any bearing on what I am doing as the cells haven't
been merged.

Nick




Nick Wakeham

Wrap Text not working in places
 
Kevin

many thanks for that but, as I said, the cells aren't merged at all - it is
So strange!!

Nick


"Kevin B" wrote in message
...
Verify that the cell where WRAP TEXT is not working are not merged cells.
If
the cells are merged the text will not wrap.

Hope this helps...
--
Kevin Backmann


"Nick Wakeham" wrote:

I have made up a new spreadsheet in Excel2007. Part of the sheet I have
copied from a Excel2003 spreadsheet and pasted it into the new one.

I have put Wrap Text as format of all cells but only the cells on the
non-pasted parts of the spreadsheet work - the cells on the part I pasted
in, although showing up in Format as having Wrap Text selected, won't
wrap -
what am I doing wrong??

Have also checked through Google and all the solutions there, such as
merged
cells, etc don't have any bearing on what I am doing as the cells haven't
been merged.

Nick







All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com