I wonder if Microsoft pays bonuses to programmers for finding things they have no reason to change, but change them anyway. Thanks for the update. Now I'm going to create a custom theme with all the new colors except for purple..... anyone got the RGB's for a cooler yellow pallet than the old one?
Great question, Martin! I've been experimenting with customizing the new palette to add yellow back into it. #FFC000 is the hex code for the old yellow color. It was actually gold. Another option I stumbled on is #ECD444. It's a bit lighter yellow and the darker shades don't look so brown compared to the old yellow/gold. I used Coolors (coolors.co/) to try and find a new yellow color based on the new palette. It's a pretty cool site. I'll probably do a follow-up video on this. Also, note that I'm not a designer, so this is not a professional opinion. 🙂
@@ExcelCampus And not necessarily in a good way. I love purple (2nd fave color), but this? I'm much older-school: I don't particularly use themes, but I do switch to the Office 2007-2010 color palette. Those color combos were/are perfect for me.
I miss the yellow too! You can customize the new palette to replace one of the colors with the old yellow. I've been experimenting with this and will probably do a follow-up video to explain more. There are some things to consider when deciding which color to replace because some of the colors are used for default table and pivot styles. I'd also like to bring back the gray color for table styles.
I'm a graphics designer and shudder when I see what kind of Excel sheets people will produce with this new default them. They don't create a harmonious color palette and dark green is way too green. Thankfully I knew how to switch.
Thanks for sharing! It's interesting to hear opinions from graphic designers. Selecting colors to use in a spreadsheet can be one of the most challenging aspects for Excel users who aren't graphics designers. I'm speaking for myself. 🙂
I'm also on the BETA version of Excel, but I had already created a custom Book.xltx and didn't know about this change! One of the things I changed was the default Row Height from 14.5 to 15 (easier to double/triple row height), but I found that adding a new Worksheet went back to the 14.5 row height. I needed to create Sheet.xltx so that new Worksheets had the same Row Height of 15 that I wanted.
Excellent summary Jon but I can see problems with the Blue to Purple shift - for years we have coded two categories as Blue and Purple - completely different classes - so I can see myself using the old theme for a while yet.
This is why I don't like the subscription model. I have used Excel for over 20 years and have my own patterns for colors, etc., and they keep changing without warning. If I had perpetual license this would now happen. June 1, 2024 now has grey across top of Excel instead of green and everything now blurs together. I cannot find out how to make it go back to green.
It would be better if Office 365 should be available to the public for free, and not relying on expensive subscriptions so that we would apply the new updates.
Well, I always clear the table format so I keep it plain but indented, and headings bolder, however, I do love the new font!!! I absolutely hate “ Calibre” whatever spelling this is ! I can tell when is calibre, any conversion of image also messes it up with the L and I (yes, when PDF doesn’t open with power query) as you pointed out. If I have invoice numbers formatting as IN1224, when I convert it, OCR messes between L and I, anyways, it’s a palavra to change it all if you have hundreds of similar reference in your table because vlookup or xlookup won’t work.
I'm so glad I found your page. My Excel just changed on 06/01/24....so a full 6 months after the change. I was able to revert back to the old style using your tips....thank you so much. I may change one day....gradually....just not now.
Thank you sharing your expertise; it really helps. I personally don't mind the purple and I'm definitely glad for something other than Calibri. But, my question is: I work as a temp for numerous companies and they all have a different color scheme. How do I turn those very specific colors into a palette I can save and use for future presentations for that specific company? I often have to quickly produce company documents that align with their unique color scheme.
I like how you're thinking ahead, Christine! In Microsoft PowerPoint, you could paste a picture of the company's logo into a slide and then use the Eyedropper feature (Ribbon > Home > Shape Fill > Eyedropper) to hover over and extract that color. The color will then be added to the Recent Colors list under Shape Fill. You can also change the slide background. I would consider creating a separate file for each company. I am not aware of an Eyedropper feature in Excel, but I hope that helps!
I wonder if Microsoft pays bonuses to programmers for finding things they have no reason to change, but change them anyway. Thanks for the update. Now I'm going to create a custom theme with all the new colors except for purple..... anyone got the RGB's for a cooler yellow pallet than the old one?
Great question, Martin! I've been experimenting with customizing the new palette to add yellow back into it. #FFC000 is the hex code for the old yellow color. It was actually gold. Another option I stumbled on is #ECD444. It's a bit lighter yellow and the darker shades don't look so brown compared to the old yellow/gold.
I used Coolors (coolors.co/) to try and find a new yellow color based on the new palette. It's a pretty cool site. I'll probably do a follow-up video on this. Also, note that I'm not a designer, so this is not a professional opinion. 🙂
Sounds promising. I might give it a try.
@@ExcelCampus
Thanks. The purple seems to be a rather rude color in the table you showed.
Haha! It definitely draws attention.
@@ExcelCampus And not necessarily in a good way. I love purple (2nd fave color), but this? I'm much older-school: I don't particularly use themes, but I do switch to the Office 2007-2010 color palette. Those color combos were/are perfect for me.
I will certainly miss the yellow colour??? I use it a lot to highlight data…. Not sur which to use now…. 😢
I miss the yellow too! You can customize the new palette to replace one of the colors with the old yellow. I've been experimenting with this and will probably do a follow-up video to explain more. There are some things to consider when deciding which color to replace because some of the colors are used for default table and pivot styles. I'd also like to bring back the gray color for table styles.
It would be nice if Microsoft made it possible to set the theme globally. Set it in settings and it's set in excel, word, PowerPoint, etc.
I am a user of the yellow colors, not good it’s not on the pallet
Not sure why Microsoft got rid of the yellow theme.
The Cyan color and a similar variant are shown twice.
I miss the yellow. That was one of the easiest on the eyes choice for on screen viewing. I can't imagine needing two different greens and blues.
I'm a graphics designer and shudder when I see what kind of Excel sheets people will produce with this new default them. They don't create a harmonious color palette and dark green is way too green. Thankfully I knew how to switch.
Thanks for sharing! It's interesting to hear opinions from graphic designers. Selecting colors to use in a spreadsheet can be one of the most challenging aspects for Excel users who aren't graphics designers. I'm speaking for myself. 🙂
I wonder if the column width issue in Excel is actually due to the change of font? Calibre is slightly wider but the column hasn't resized?
I'm also on the BETA version of Excel, but I had already created a custom Book.xltx and didn't know about this change! One of the things I changed was the default Row Height from 14.5 to 15 (easier to double/triple row height), but I found that adding a new Worksheet went back to the 14.5 row height. I needed to create Sheet.xltx so that new Worksheets had the same Row Height of 15 that I wanted.
Great tip! Thanks for sharing, Jerry! 🙂
A very complete tutorial about this topic. Thank you Jon!!!
Thanks Ivan! 🙂
Never was a fan of yellow. Any light color will do for highlighting. So new colors are fine!
Excellent summary Jon but I can see problems with the Blue to Purple shift - for years we have coded two categories as Blue and Purple - completely different classes - so I can see myself using the old theme for a while yet.
Interesting. Thanks for sharing and for the nice feedback. 🙂
Excellent video-very professional and straight to the point. Thank you!
Thank you for your feedback! 😀
I like the new brighter colors and will be using them, I agree with you the font is better too.
This is why I don't like the subscription model. I have used Excel for over 20 years and have my own patterns for colors, etc., and they keep changing without warning. If I had perpetual license this would now happen. June 1, 2024 now has grey across top of Excel instead of green and everything now blurs together. I cannot find out how to make it go back to green.
Try File>More>Options>General
Half Way down Personalise your copy of Microsoft Office > Office Theme
Change it to Colorful
@@alexb9312 Thanks!
It would be better if Office 365 should be available to the public for free, and not relying on expensive subscriptions so that we would apply the new updates.
I like the new color themes
i dont have it. was it removed?
Well, I always clear the table format so I keep it plain but indented, and headings bolder, however, I do love the new font!!! I absolutely hate “ Calibre” whatever spelling this is ! I can tell when is calibre, any conversion of image also messes it up with the L and I (yes, when PDF doesn’t open with power query) as you pointed out. If I have invoice numbers formatting as IN1224, when I convert it, OCR messes between L and I, anyways, it’s a palavra to change it all if you have hundreds of similar reference in your table because vlookup or xlookup won’t work.
Hi Jon Long Time No Seee ....Nice to see you
Hey there @rtrbs8383 ! 😀
I'm so glad I found your page. My Excel just changed on 06/01/24....so a full 6 months after the change. I was able to revert back to the old style using your tips....thank you so much. I may change one day....gradually....just not now.
You're welcome! 😀
Thank you sharing your expertise; it really helps. I personally don't mind the purple and I'm definitely glad for something other than Calibri. But, my question is: I work as a temp for numerous companies and they all have a different color scheme. How do I turn those very specific colors into a palette I can save and use for future presentations for that specific company? I often have to quickly produce company documents that align with their unique color scheme.
I like how you're thinking ahead, Christine! In Microsoft PowerPoint, you could paste a picture of the company's logo into a slide and then use the Eyedropper feature (Ribbon > Home > Shape Fill > Eyedropper) to hover over and extract that color. The color will then be added to the Recent Colors list under Shape Fill. You can also change the slide background. I would consider creating a separate file for each company. I am not aware of an Eyedropper feature in Excel, but I hope that helps!
Bruh
Excellent explanation and tutorial, sir. Thanks for sharing 👍
You're welcome 😀
hi,
is it worth it upgrading from office 2019 to 2021?
All I wanted to know is how to change the banner colors.