MrExcel Excel Videos

Ryan has a data set where all of the fields are going down column A and he would like to take this column of data back into a rectangular range. Normally, I would use a macro to do this, but today, a single INDEX formula copied through the range does the trick.

There are too many ways to copy charts from Excel to PowerPoint. Do it wrong, and the person with your PowerPoint can access the entire Excel Workbook. Ever since Office 2010, I prefer using the Screen Clipping Tool to get a perfect representation of the chart. This tool is great for copying screenshots from the web or any application into your Excel, Word, or PowerPoint documents.

I used to solve this problem with Home, Find & Select, Go To Special, Blanks, OK, 0, Ctrl+Enter. There is a faster way, using Ctrl+H, as shown in today's episode.

Phoebe from Florida has a spreadsheet where gridlines are missing from just one section of the worksheet. Today, two theories on how that happened, how to fix it, and, since we are covering gridlines, how to toggle gridlines off and on for the whole workbook and how to change the gridlines to an annoying red color.

When you run your data through PowerPivot, you can not group daily dates up to Months & Years as you can with a regular pivot table. Episode 1886 shows how to use a Calendar table to group and sort in Power Pivot. Check out the new Power Pivot Alchemy book at Power Pivot, PowerPivot, Excel, Excel 2010, Excel 2013, Microsoft Excel, Microsoft Power Pivot

Have you ever discovered crazy steps that will actually cause the macro recorder to work? In today's episode, I share my way to have the Macro Recorder successfully record the AutoSum. But, I am looking for a way to use the macro recorder to record a Sort.

Mysteriously, some Excel cells are showing a leading space. But when you double-click to edit the cell, the leading space disappears! The cells are left-justified, no indent. What is causing the problem?

Today's question: You have to rent rail tank car #123 for a 3 month period. The daily rate changes twice ; once in May, and once in June. Given the start date, end date, and the rate changes, how can you calculated the total rental charge or average per day? Bill shows how he has been reading MIke's Ctrl+Shift+Enter book and creates an array formula. Mike makes the formula better. Links: Mike's Ctrl+Shift+Enter book: Ctrl + Shift + Enter Bill's May 9 seminar in Tampa: https://www.eventbrite.com/e/bill-mrexcel-jelen-at-spring-ima-fl-council-seminar-8-cpe-tickets-10676733397 Mike's appearance on ExcelTV:

On Sheet 1, you have customer data with subtotals added by the Subtotal command. On Sheet 2, you have a list of customers. How do you do VLOOKUP from Sheet 2 to get the total for each customer from Sheet 1? This question was posed during my Fort Wayne seminar. In episode 1882, two possible ways to solve the problem.