I received the excelTip today on how to add a style box to the toolbar,
then adding wrap text to the style box. Works great, but...
the wrap text is gone when you open a new worksheet. This would be
much better if you could keep it available for every instance of excel.
I tried putting this in the personal.xls file, because that is always
open, but that didn't work either. Is their a fix? - or did I do
something wrong?--
justme2
------------------------------------------------------------------------
justme2's Profile: www.excelforum.com/member.php...oamp;userid=30357
View this thread: www.excelforum.com/showthread...hreadid=500143You'd need to put those preferences into the templates that Excel uses for
new workbooks and new sheets.
Per Excel help:
Storing default workbook and worksheet templates
If you've created a template named Book.xlt or Sheet.xlt and saved it in the
XLStart folder, Microsoft Excel uses the template to create new default
workbooks or to insert new worksheets. The XLStart folder is usually located
at:
C:\Program Files\Microsoft Office\Office10\XLStartDoes that help?
***********
Regards,
Ron
XL2002, WinXP-Proquot;justme2quot; wrote:
gt;
gt; I received the excelTip today on how to add a style box to the toolbar,
gt; then adding wrap text to the style box. Works great, but...
gt;
gt; the wrap text is gone when you open a new worksheet. This would be
gt; much better if you could keep it available for every instance of excel.
gt; I tried putting this in the personal.xls file, because that is always
gt; open, but that didn't work either. Is their a fix? - or did I do
gt; something wrong?
gt;
gt;
gt; --
gt; justme2
gt; ------------------------------------------------------------------------
gt; justme2's Profile: www.excelforum.com/member.php...oamp;userid=30357
gt; View this thread: www.excelforum.com/showthread...hreadid=500143
gt;
gt;
- Apr 13 Sun 2008 20:43
Shortcut for wrapping text
close
全站熱搜
留言列表
發表留言