jmatty2000
New Member
- Joined
- Apr 20, 2022
- Messages
- 8
- Office Version
- 365
- 2016
- Platform
- Windows
- Mobile
- Web
Hi
I'm new to this forum so hi from me and I hope you are fine.
I'm using a spreadsheet which uses an excel template. I've saved the templates as book.xlxt and sheet.xltx to my %appdata%\Microsoft\Excel\XLSTART folder so that this spreadsheet always creates the same template worksheet when I insert another one. The template works absolutely fine when I load excel and the template loads great when I create a new worksheet.
Anyway, sometimes I just want to use a blank worksheet without all the template formatting getting in the way - just to make seperate notes on something (I work in IT so sometimes there is a big error stack that I want copy and paste without clustering up my template)
For example, if I create a new worksheet then the template loads up as expected and if I just want a blank worksheet to play about on (to make seperate notes), I have to highlight all the cells to delete them, re-add all the borders to the cells and resize the cell widths and heights.
Anyway know how to override the template so I can just insert a blank worksheet whenever I need one please?
Kind Regards
Matt
I'm new to this forum so hi from me and I hope you are fine.
I'm using a spreadsheet which uses an excel template. I've saved the templates as book.xlxt and sheet.xltx to my %appdata%\Microsoft\Excel\XLSTART folder so that this spreadsheet always creates the same template worksheet when I insert another one. The template works absolutely fine when I load excel and the template loads great when I create a new worksheet.
Anyway, sometimes I just want to use a blank worksheet without all the template formatting getting in the way - just to make seperate notes on something (I work in IT so sometimes there is a big error stack that I want copy and paste without clustering up my template)
For example, if I create a new worksheet then the template loads up as expected and if I just want a blank worksheet to play about on (to make seperate notes), I have to highlight all the cells to delete them, re-add all the borders to the cells and resize the cell widths and heights.
Anyway know how to override the template so I can just insert a blank worksheet whenever I need one please?
Kind Regards
Matt