MrExcel Excel Videos

When you copy and paste data from a web browser to Excel, a number of maddening settings come along with the data. In Episode 362, I will show you how to turn off the wrap text feature and get the columns wide enough to fit the data. 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!

Bruce from Texas calls in today with an Excel problem. Bruce needs to turn a worksheet on its side, moving the rows to columns and columns to row. Episode 361 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!

Today on Episode 360, a viewer question stumps MrExcel. Well, there are two solutions in the podcast, but like you, I have to believe there is a better way. The question is how to add a page break every 35 rows. If you know a better way to do this, leave a message at 866-581-0221. 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!

In Episode 1137, a cool way to remove all hyperlinks from a spreadsheet. 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!

Create cool headlines by adding text to your autoshape and then formatting it using the drawing toolbar. Episode 369 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!

Use the AutoShapes to draw any of 70 different shapes to your workbook. Episode 368 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!

Using the circle tools on the Drawing toolbar to call attention to a cell. Episode 367 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!

Use the drawing tools to highlight data on your worksheet. Episode 366 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!

Back in August, the podcast showed a trick for precenting people from going outside a certain range of the worksheet. Today, a caller points out that this setting is lost when you close and re-open the workbook. Today's postcast shows how to create a simple one-line macro using Worksheets("Sheet1").ScrollArea = "A1:J10" to ensure that the setting always comes back. Episode 365 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!