J janet Nov 20, 2006 #1 If you create a new table style in Excel 2007 is it possible to save it for use in future workbooks? Thanks 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 Nov 20, 2006 #2 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 (e-mail address removed) www.nickhodge.co.uk
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 (e-mail address removed) www.nickhodge.co.uk
J janet Nov 21, 2006 #3 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 (e-mail address removed) www.nickhodge.co.uk Click to expand...
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 (e-mail address removed) www.nickhodge.co.uk Click to expand...
