Changing rows and columns size across all workbooks

[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

 

[GB]

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