Forum Discussion
The cells color theme
I hope that you won't ever need to print out a worksheet - it would use up a lot of toner!
Create a blank workbook and modify the Normal style to have a black background and white font.
Save this workbook as an Excel template (.xltx) named Book.xltx in Excel's startup folder (by default %AppData%\Microsoft\Excel\XLSTART). The name Book.xltx is mandatory for the English version of Excel; it is language-dependent - for example, in French it is Livre.xltx.
Also create a version of this template with just one worksheet and save it as a template named Sheet.xltx in the same folder. The name is mandatory again, but language-dependent; in French it would be Feuil.xltx).
Excel will use these when you press Ctrl+N or click the New button on the Quick Access Toolbar to create a new workbook, and when you click the + to insert a new worksheet.
HansVogelaar , I never I thought I'll need it, but now I have to bring the settings back. I deleted two templates from the XLSSTART folder, but excel is still opens deleted templates instead of white normal book. And by the way when I open downloaded (external books) the program opens 2 books instead of downloaded one, the second extra book is the template from XLSSTART. How can I bring everything back to normal white (to preinstalled default)?
Also there were some problems with the "Excel" and "XLSSTART" folders: there were absent when I searched for it directly. They haven't appeared even when I managed to show all hidden folders. But when I browse the directory through excel "save as" and then search the route to save the file, those disguised folders suddenly appear.
Would you be so kind to help me unravel the mystery here?
It's not XLSSTART but XLSTART.
The XLSTART folder is in a folder that is normally hidden by Windows. To be able to see it:
Start File Explorer.
On the View tab of the ribbon, click Options.
Activate the View tab.
Under 'Hidden files and folders', select 'Show hidden files, folders and drives'.
Click OK.
HansVogelaar Thank you!