Sep 27 2021 10:53 AM
Hi,
Love Ctrl-N command which opens a default blank page.
BUT, I'm trying to find how i can permanently change that default blank page to a page I have formatted.
Note: this is NOT an XL startup question. This is ONCE Excel is already up and running, and I hit 'Ctrl'-N'. I want to change that blank page that opens up.
Any ideas out there ?
Thank you
Suzanne
Sep 27 2021 11:31 AM
Yes, it is in fact related to XLSTART.
If you create a blank workbook with the formatting that you like, and save it as an Excel template named Book.xltx in your XLSTART folder (%appdata%\Microsoft\Excel\XLSTART), then Excel will use this template when you press Ctrl+N.
Sep 27 2021 11:48 AM - edited Sep 27 2021 11:49 AM
Thanks for getting back to me quickly.
I just set it up the way you described. It opened my formatted xl at startup, but still does not open it at Ctrl-N. At Ctrl-N, it still goes with the default xl workbook.
Any other thoughts?
I'm on MS Office 365 Apps for Business, Subscription Product. If that helps at all.
Thank you
-S.