Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I save more colors to current available colors? bwhite Excel Discussion (Misc queries) 1 January 9th 09 07:49 PM
Excel 2007 will not save Recent Documents Gren New Users to Excel 3 April 30th 08 06:08 PM
create chart /table excel-save, close & reopen colors change? Why Anne Charts and Charting in Excel 1 July 4th 06 09:16 PM
How do I save colors when pasting from excel to powerpoint? finance geek Excel Discussion (Misc queries) 0 April 21st 06 02:21 AM
How to set up my EXCEL so it takes me to most frequently used directory? Y T via OfficeKB.com Excel Discussion (Misc queries) 1 August 8th 05 08:08 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"