Kyle sends in a different way to transpose with a formula - the array function =TRANSPOSE will do the trick. Also, Joe and Adrien check in with alternate ways of closing Excel. Episode 841 shows 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!
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!
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, let's do a couple of corrections & amplifications here.
Let's go back to Episode 835: We wanted to Transpose with a formula; I'd used a combination of INDEX and COLUMN, I think, to do that; and Kyle Munson wrote in and said, "Hey, you know, that's fine, there's another way to do it, though, using the Transpose function." And basically, what we have to do is select all of the cells where we want that formula to be, and type =TRANSPOSE, and then point to our vertical array.
Now, in order to enter this one formula into all of the cells, of course we have to press Ctrl+Shift+Enter, and sure enough, it does create a nice live Transpose formula.
So, if I, for example, change this to 9999 here, the cell in G2 goes ahead and changes.
So it's a little bit tougher to use because it's an array formula, but it is one formula and, you know, it does the job fairly well.
And then let's go back to 833-- in 833 I talked about how do we close Excel.
I showed the double-click the Office icon, and completely missed that that tip had previously been sent in by Adrian Cooper.
I was just going back through old podcast emails and Adrian sent that tip in, so tip of the hat to Adrian for sending in that great tip.
And then Joe Martin-- you know, Joe is a frequent contributor to the podcast-- he says, "You know, hey, if you need to close Excel and you know, you're frustrated in Excel 2007, the X up here isn't working, you know, our old friend Alt+F4 will close any application." So hold down Alt, press F4, and you're going to close Excel.
Of course that works in the old Excel as well as the new Excel-- just Alt+F4 actually works in any application.
Great way to close applications.
My kids have these video games, sometimes they leave them running on the computer and I can't find where the menu is-- Alt+F4 is a great way to get out of that application, short of using Ctrl+Alt+Delete.
Well, there you have it, thanks for stopping by.
I will see you next time for another netcast for MrExcel.
[ music ]
Well, let's do a couple of corrections & amplifications here.
Let's go back to Episode 835: We wanted to Transpose with a formula; I'd used a combination of INDEX and COLUMN, I think, to do that; and Kyle Munson wrote in and said, "Hey, you know, that's fine, there's another way to do it, though, using the Transpose function." And basically, what we have to do is select all of the cells where we want that formula to be, and type =TRANSPOSE, and then point to our vertical array.
Now, in order to enter this one formula into all of the cells, of course we have to press Ctrl+Shift+Enter, and sure enough, it does create a nice live Transpose formula.
So, if I, for example, change this to 9999 here, the cell in G2 goes ahead and changes.
So it's a little bit tougher to use because it's an array formula, but it is one formula and, you know, it does the job fairly well.
And then let's go back to 833-- in 833 I talked about how do we close Excel.
I showed the double-click the Office icon, and completely missed that that tip had previously been sent in by Adrian Cooper.
I was just going back through old podcast emails and Adrian sent that tip in, so tip of the hat to Adrian for sending in that great tip.
And then Joe Martin-- you know, Joe is a frequent contributor to the podcast-- he says, "You know, hey, if you need to close Excel and you know, you're frustrated in Excel 2007, the X up here isn't working, you know, our old friend Alt+F4 will close any application." So hold down Alt, press F4, and you're going to close Excel.
Of course that works in the old Excel as well as the new Excel-- just Alt+F4 actually works in any application.
Great way to close applications.
My kids have these video games, sometimes they leave them running on the computer and I can't find where the menu is-- Alt+F4 is a great way to get out of that application, short of using Ctrl+Alt+Delete.
Well, there you have it, thanks for stopping by.
I will see you next time for another netcast for MrExcel.
[ music ]
