Excel 2007 Table Styles

J

janet

If you create a new table style in Excel 2007 is it possible to save it

for use in future workbooks?

Thanks

Janet
 
N

Nick Hodge

Janet

Open a workbook and set your table style. Delete the table once you have
done this. You can also set it as the default at this point

Save the file to your xlStart folder as an Excel Template called book.xltx.
This will then be available in every workbook opened.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

[email protected]
www.nickhodge.co.uk
 
J

janet

Nick,

Many thanks

Janet
Nick said:
Janet

Open a workbook and set your table style. Delete the table once you have
done this. You can also set it as the default at this point

Save the file to your xlStart folder as an Excel Template called book.xltx.
This will then be available in every workbook opened.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

[email protected]
www.nickhodge.co.uk
Click to expand...
 
Top