Hi
On one spreadsheet I use the Cell > Fill, colors have changed (first pic below) and I can't get them back to the default colours
Default colours below
I've been fiddling around around trying to solve this, I've been unsuccessful!
Thanks
Choose the multicolored circle next to the color as shown in the top arrow, then choose the color palette at the second arrow.
Choose the multicolored circle next to the color as shown in the top arrow, then choose the color palette at the second arrow.
Thanks, I tried this but the colours in the Colour Fills box are the same as my first screen shot, they haven't reverted back.
I also don't have the smaller colour boxes at the bottom of your screen shot - mine are empty ( I have no idea if this is relevant)
This is an Excel color palette. Was this an imported spreadsheet?
The only way I recall to get the normal color palette is to start a new document and copy/paste everything over to it.
If your document is a single sheet, copy/paste the entire sheet to the new document or Select All and copy/paste all objects from the sheet to a sheet in the new document.
If your document is multiple sheets and no formulas or charts on a sheet reference cells on other sheets, repeat that process for the other sheets.
If your document is multiple sheets with formulas or charts that reference other sheets, move everything that is interrelated to one sheet then copy/paste the sheet to the new document. (Use Cut/Paste to move objects from one sheet to another.)
How to get the Cell > Fill colours back to the default palette
