MrExcel's Learn Excel #984 - Snaking Columns

You have a really long data set with all of the data in column A. When you print, you will be wasting 75% of the horizontal white space on the page. Is there any way to have the column A data snake through the other columns? It would be nice if there was a checkbox for this, but Episode 984 resorts to using INDEX, ROW and COLUMN!

This video is the 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!

MrExcel's Learn Excel #951 - EOMonth Sorting Word

Jamie shows how to use EOMonth to find the first of next month and Melanie shows how to sort paragraphs in Word. Episode 951 shows you how.

This video is the 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!

MrExcel's Learn Excel #944 - Excel to Word

In Episode 943, I took data from Word and pasted to Excel for sorting. Now, I need to "type" that data back into Word, using the proper Style for each paragraph. Episode 944 shows you an Excel macro to automate this process.

This video is the 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!

MrExcel's Learn Excel #943 - Sorting Word Paragraphs

Bill (me) asks... is there any way to sort paragraphs in Word? I still don't know the answer, but in Episode 943, I show you how to take the data to Excel, add a few new columns and successfully sort groups of records in Excel.

This video is the 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!

Episode 906 - Holiday Mail Merge

Take mailing list data from Excel and produce labels in Word. Episode 906 will show you how.

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!

Episode 567 - Truncation Justify

Are you a fan of Edit – Fill – Justify? If so, watch out if you try to justify particularly long text – anything over 255 characters in a cell. Excel fails miserably, and you lost part of your text, without any warning from Excel. Episode 567 shows you the details.

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!

Episode 473 - Formulas in Word

Sure – it is easy to add up a column of numbers in Excel, but did you know that you can do this in Microsoft Word as well? Our guest host today is Word MVP Tony Jollans. In Episode 473, Tony shows you how to add up a column of numbers in Word.

Episode 356 - Customizing Icons

You probably know that you can add new icons to your Excel toolbars, but did you know that those icons can also come from Word or PowerPoint? Episode 356 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!