ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I save the Recent Colors that I frequently use in Excel. (https://www.excelbanter.com/excel-discussion-misc-queries/227330-how-do-i-save-recent-colors-i-frequently-use-excel.html)

ron13106

How do I save the Recent Colors that I frequently use in Excel.
 
Standard color palette too dull. Use 6 or 7 normal colors but Excel doesn't
remember which colors I used previously. How to I change the standard color
palette or get Excel to remember my recent colors.

ExcelBanter AI

Answer: How do I save the Recent Colors that I frequently use in Excel.
 
Hey there! I can definitely help you with that. Excel has a feature that allows you to save your frequently used colors as Recent Colors. Here's how you can do it:
  1. Open Excel and click on the "Home" tab.
  2. Click on the "Font Color" or "Fill Color" button (depending on whether you want to save a font or fill color).
  3. Click on the "More Colors" button at the bottom of the color palette.
  4. In the "Colors" tab, select the color you want to save as a Recent Color.
  5. Click on the "Add to Custom Colors" button.
  6. The color will now appear in the "Custom Colors" tab. Click on the "OK" button to close the "Colors" window.
  7. Now, whenever you click on the "Font Color" or "Fill Color" button, your Recent Colors will appear at the top of the color palette.

If you want to change the standard color palette, you can do so by following these steps:
  1. Open Excel and click on the "File" tab.
  2. Click on "Options" at the bottom of the left-hand menu.
  3. Click on "General" in the left-hand menu.
  4. Scroll down to the "Color" section and click on the "Color Scheme" dropdown menu.
  5. Select the color scheme you want to use.
  6. Click on the "OK" button to save your changes.

FSt1

How do I save the Recent Colors that I frequently use in Excel.
 
hi
custom color follows the file in which they were created. so if you open a
blank file, they revert back to default.
To keep the new color palette permanent you need to save the file with the
custom colors as an xl template (.xlt) which is the .XLT file in the XLStart
folder. open a worksheet, create your color pallette, then save the file to
the location above with extention .XLT instead of .XLS. after that every new
workbook you create will have your custom color pallett

regards
FSt1

"ron13106" wrote:

Standard color palette too dull. Use 6 or 7 normal colors but Excel doesn't
remember which colors I used previously. How to I change the standard color
palette or get Excel to remember my recent colors.



All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com