What the heck is the SPLIT command for? Episode 1098 wonders about this.
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.
Basically, we start out with massive amounts of data.
How we're gonna analyze this. Well, let's fire up a pivot table and see you can solve this problem Hey, welcome back to MrExcel netcast.
I'm Bill Jelen.
I got a great puzzle for you today here.
Do you get the text support calls you you know you get Mom or Grandma called up and said I got a computer question I get them all the time, and I just got an Excel question for my brother in law, he says, I've got the weirdest thing.
He says I was, I was copying and pasting I left clicked or I right clicked or I did something and all of a sudden now baam.
I have exact copy of my spreadsheet to the right of my spreadsheet.
I like what what are you talking about, he says, yeah, I have columns A through E and then to the right of that Is all of that data from A3 again, I have no idea how it got there.
I said, okay that sounds we were the first thing I thought is somehow he managed to use the camera tool to make a picture when I said, okay I want you to come over here and left click on the right side and look for the handles. The object handles that would show up.
No nothing there alright so, maybe those formulas let's come over here and choose one of these cells and see if it's a formula cell over here that pointing back to column aces no not formulas.
It's just text and then he gives me one more clue, and this one actually just really throws me for a loop he says when I choose column A on the left that column A that I see on the right gets chosen as well, and if I type something here, it happens on the other side.
I'm like okay now, you could use window new window and then window arrange horizontal, but there's no way he managed to do that with a left click or a right click.
And so, finally I just gave up I said send me the file, I I've got to see the file.
So, then the file shows up here all right and I realized what he didn't tell me was this little bar heading down the middle that he had somehow managed to do View, split in Excel 2007, he's actually using excel 2003.
So, that would have been window split and manage to split the window.
Let's turn that off so, I guess he was here probably an F1 managed to do the split command and then somehow backed into column A.
And now, it is very weird because we have to identical copies of the worksheet.
Do something on the left side and it appears on the right side.
So, easy solution form just turn off the split, right?
But here's my question for you.
I'm a big fan of Freeze Panes.
I use Freeze Panes all the time, but I frankly have never found a reason to use split.
So, I'm sure out there all the people watching the podcast some of you must love split and you split all the time.
I guess you could use split, if you needed to see, maybe on the left side columns A through something and on the right-hand side something else, but again, I would use window new window to do that and then window arrange vertical, so we could see them side-by-side.
So, for all of you split fans out there anyone who enjoys using split why don't you write into bill@mrexcel.com.
Let me know what you you split for, what you know is it the spreadsheet is too big you know frankly You know for my money. I would just as soon take it out of the ribbon because well in this case it caused something very very confusing to happen.
Freeze Panes is a better way to go so, right in. Let me know and I'll report back in a future podcast if all the great ideas we had, for the split command.
Oh hey, I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Well, thanks for stopping by.
We'll see you next time for another netcast MrExcel.
I'm Bill Jelen.
Basically, we start out with massive amounts of data.
How we're gonna analyze this. Well, let's fire up a pivot table and see you can solve this problem Hey, welcome back to MrExcel netcast.
I'm Bill Jelen.
I got a great puzzle for you today here.
Do you get the text support calls you you know you get Mom or Grandma called up and said I got a computer question I get them all the time, and I just got an Excel question for my brother in law, he says, I've got the weirdest thing.
He says I was, I was copying and pasting I left clicked or I right clicked or I did something and all of a sudden now baam.
I have exact copy of my spreadsheet to the right of my spreadsheet.
I like what what are you talking about, he says, yeah, I have columns A through E and then to the right of that Is all of that data from A3 again, I have no idea how it got there.
I said, okay that sounds we were the first thing I thought is somehow he managed to use the camera tool to make a picture when I said, okay I want you to come over here and left click on the right side and look for the handles. The object handles that would show up.
No nothing there alright so, maybe those formulas let's come over here and choose one of these cells and see if it's a formula cell over here that pointing back to column aces no not formulas.
It's just text and then he gives me one more clue, and this one actually just really throws me for a loop he says when I choose column A on the left that column A that I see on the right gets chosen as well, and if I type something here, it happens on the other side.
I'm like okay now, you could use window new window and then window arrange horizontal, but there's no way he managed to do that with a left click or a right click.
And so, finally I just gave up I said send me the file, I I've got to see the file.
So, then the file shows up here all right and I realized what he didn't tell me was this little bar heading down the middle that he had somehow managed to do View, split in Excel 2007, he's actually using excel 2003.
So, that would have been window split and manage to split the window.
Let's turn that off so, I guess he was here probably an F1 managed to do the split command and then somehow backed into column A.
And now, it is very weird because we have to identical copies of the worksheet.
Do something on the left side and it appears on the right side.
So, easy solution form just turn off the split, right?
But here's my question for you.
I'm a big fan of Freeze Panes.
I use Freeze Panes all the time, but I frankly have never found a reason to use split.
So, I'm sure out there all the people watching the podcast some of you must love split and you split all the time.
I guess you could use split, if you needed to see, maybe on the left side columns A through something and on the right-hand side something else, but again, I would use window new window to do that and then window arrange vertical, so we could see them side-by-side.
So, for all of you split fans out there anyone who enjoys using split why don't you write into bill@mrexcel.com.
Let me know what you you split for, what you know is it the spreadsheet is too big you know frankly You know for my money. I would just as soon take it out of the ribbon because well in this case it caused something very very confusing to happen.
Freeze Panes is a better way to go so, right in. Let me know and I'll report back in a future podcast if all the great ideas we had, for the split command.
Oh hey, I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Well, thanks for stopping by.
We'll see you next time for another netcast MrExcel.
