I have the 2007 Edition of Excel. I want to all the cells to allow text
wrapping. I can select by row or column and format the cells, but it won't
save. I've also tried to select the entire page from the top left corner, but
nothing will work. I must continue to format and wrap text by each cell. Help!

Have you set rows to Autofit after selecting the whole sheet?

These are worksheet settings only and have to be re-done on all sheets.

New workbooks and New worksheets won't have these settings unless you create
Templates for New workbook and worksheet which override Excel's default
workbook and worksheet.


Gord Dibben MS Excel MVP



On Thu, 14 Jan 2010 14:52:01 -0800, Martha
<(E-Mail Removed)> wrote:

>I have the 2007 Edition of Excel. I want to all the cells to allow text
>wrapping. I can select by row or column and format the cells, but it won't
>save. I've also tried to select the entire page from the top left corner, but
>nothing will work. I must continue to format and wrap text by each cell. Help!