It is easy to create a custom theme in Excel 2007. This theme might contain custom colors, fonts, and effects. Episode 531 shows you how to define a theme and share it with others.
This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the 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…
In Excel 2007, a theme is comprised of fonts, colors, and effects. Episode 530 helps to decode the information in the effects thumbnails.
This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the book!
Uma wants to create many worksheets in a new workbook that are named after values in range B2:B20. Episode 1072 shows a VBA macro that makes all of this possible.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Terry from Springfield, MO asks about a quicker, one-click way to change the Move Selection After Enter direction. Episode 1071 show you how to solve this problem by recording a couple of quick macros.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Sparklines are tiny, word-sized charts that can appear in a cell. Excel 2010 makes it easy to create sparklines. In Episode 1070, Mike & Bill show you several examples in Excel 2010.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Simon from the UK sends in a question. He has a range of negative numbers that he needs to convert to positive values. Episode 549 shows you two methods for converting the values to positive.
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 navigate your worksheet rows by dragging your scrollbar slider, in some Excel worksheets, the scrollbar slider becomes incredibly small. In Episode 548, I show my one trick for solving this problem, but I expect that there are other solutions.
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!
Today, Bob calls in with a question. He has an Excel spreadsheet where someone managed to cross out only part of a cell. For example, someone crossed out the original due date and then keyed a new due date in the same cell and the new date does not have the strikethrough formatting applied. Episode 547 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!
