Excel--wrap text set as default?

[atadbitslow]

Is there a way to have all new Excel files wrap text in all the cells of a worksheet? I'd like this as a default. Do I have to create a new template? Is there a way to edit the default template?

thanks!

 

[dawnd3]

Yes. Create a new spreadsheet with the defaults you want. Then save the file as an .xlt in the XLStart folder. I believe you need to name the file "book". For more detailed instructions look up "Create a workbook template for new workbooks" in the help menu."

Hope this helps.

Dawn

http://www.calliopeconsulting.net

 

[doldol]

what do you mean by wrap text?
you mean you want to set a font which you prefer?

then do the following ;
tools -> options -> General -> Standard font : Select & size.

 

[dawnd3]

doldol, wrap text is an option under format, cells, alignment that allows the text in cell to wrap like a paragraph. If you have a long string of text but don't want the column to be that wide, then you set the wrap text option so you can read the contents of the cell.

Dawn

http://www.calliopeconsulting.net