Changing rows and columns size across all workbooks

  • Thread starter Thread starter Stephanie R
  • Start date Start date
S

Stephanie R

Hello! Is there a way to adjust the rows and columns on a
workbook and have these changes apply to all workbooks?

Thanks in advance!

Stephanie
 
You can have it apply to all new workbooks that you set up. To do that you
need to make a template file called Book.xlt placed in your xlstart
directory.

Basically you just se a blank workbook up the way you want it. Then save it
using the save as option and changing the file type to template - save in
xlstart as book.xlt.

Check the help file if you need any more info. Also, if you already have a
book.xlt file I suggest keeping a copy of the original version.

HTH

Geoff
 
Back
Top