Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Roy asks how to prevent a workbook from being saved until the workbook is complete. Episode 1118 will show you the four lines of VBA needed to make this happen.
posted by Bill at 9:00 AM
Shaun asks how he can link values in one worksheet to a lookup table in an external workbook. Episode 1082 will show you how.
posted by Bill at 9:00 AM
I've shown how to make copies of a worksheet within a workbook before, but in today's podcast, someone asks if you can drag a worksheet to a new workbook. Episode 850 shows you how. Also - in honor of the 750th podcast episode, a new contest for Saturday.
posted by Bill at 9:00 AM
Rene from Norway asks how to modify the code from podcast 730 in order to create a new workbook for every department. Episode 754 shows you how.
posted by Bill at 9:00 AM
Joe writes in with a faster way to get an entire workbook into Group mode. This is a fast way to make changes to all of the sheets in a workbook. Episode 513 shows you how.
posted by Bill at 9:00 AM
This netcast has a couple of tips from Tools - Options - General. First, learn how to control the number of worksheets in your new workbooks. Second, learn how to increase the number of files in your recently used file list. Plus a sneak peak in Episode 421 of how the Recently Used File List is improved in Excel 2007.
posted by Bill at 9:00 AM
It is a real pain to try to trace precedents that are on other worksheets or in other workbooks. Episode 400 shows some formula auditing tricks, including a trick to see all of the precedents on other worksheets. This is our 300th episode!
Labels: formula, trace precedents, Workbooks, Worksheet
posted by Bill at 9:00 AM
Jim from Montreal calls in today to ask if there is any way to change the grey background lurking behind your workbooks in Excel. While there is a setting that will adjust this background, it also annoyingly changes many other items as well. Episode 390 shows you how.
Labels: Customizing, Workbooks
posted by Bill at 9:00 AM
Are you frustrated that as you print each worksheet in a workbook, the page numbers constantly start over at page 1? Use Group mode to have your page numbers appear correctly when printing many sheets. Episode 354 shows you how.
Labels: page numbers, Workbooks, Worksheet
posted by Bill at 9:00 AM
