Once you have a custom color palette set up in Excel, see how you can easily copy it to other existing workbooks. Episode 528 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Filters
Show only:
Loading…
Rather than modify the 56 colors for every new workbook, Episode 527 shows you how to save your color choices in a template so that they will be inherited by all future workbooks.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Excel 97 through Excel 2003 was limited to 56 colors, but you dont have to keep the 56 colors that Microsoft chose. You can customize the colors for any workbook. Episode 526 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Gary sent in a better way to build MegaFormulas. Gary must be catching up on old podcasts, because he sent a note about Episode 387. Compare my way and Garys way of building MegaFormulas in Episode 525.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Ammar from Iran sends in a question about how to find the last Saturday of any given month. Episode 524 shows how to use a couple of analysis toolpak functions to solve this problem.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
JJ writes in with a question from Alaska. His home office keeps sending him data with airline in column A and flight number in column B. In order to use this data, he needs to join both values into a single cell. Episode 523 shows how to use concatenation to solve the problem.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
The Find command seems to work perfectly with text, but always has problems with finding numeric values. It is possible to find numbers with the Find command in Excel, but you have to know some fairly arcane steps. Episode 522 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Dermot sends in todays question; a spreadsheet is showing zeroes as a dash, and positive numbers with a plus sign! It turns out that the custom number format has four zones, where you can specify different formatting for positive, negative, zero, and text values. Episode 521 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Sometimes, your company tradition will force you to sort into neither ascending or descending sequence. Episode 520 shows you how to set up a custom sort in Excel 2003 or Excel 2007.
This blog is the video podcast companion to the book, Learn Excel from MrExcel and Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the books!
