Open a new tab to a table?

[Jiveman7]

Hi,

is there a way to define it so that when i open a new tab, instead of getting the normal blank tab, i get a tab with a specific table?

thx!

[Kaper]

Try right-click on the tab of the existing sheet, and then from pop-up menu select Insert, and then second tab (worksheets) - then you can insert whole template into your workbook.
Of course these are pre-defined templates (often with more than one sheet). But once you see the mechanism is working for you, create an empty table template, save it and use as any of these pre-defined ones.

[Jiveman7]

so there's no way to do it automatically?

[Kaper]

As far as I'm aware: not.
You can setup a default template for a new workbook. Once you have it ready, save it as Book.xltx * in location similar to C:\Users\Jiveman\AppData\Roaming\Microsoft\Excel\XLSTART
Unfortunately - this template is used automatically only for new workbook creation. If you add new worksheet - you shall manually show which template shall be used.

*) In national versions other name shall be used,. For instance in Excel PL a newly created workbook is not Book1.xlsx but Zeszyt1.xlsx
So the template to be saved in XLSTART shall be named Zeszyt.xltx

[Jiveman7]

ok, thx for the tip!