Three quick tips and a quiz question. It is a holiday weekend in the United States, but Episode 795 strings together a few tips that are too short for their own podcast, plus a viewer challenge at the end.
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. Alright. Welcome back to the MrExcel netcast, episode 795.
Now, in the United States, we’re off today.
It's the 4th of July, Independence Day, but we're going to do a couple of…actually, several different things today, a couple of quick little tricks.
First of all, usually when I'm doing my seminar, I never cover this in the seminar, but people start to say, well, hey, how are you switching from sheet to sheet to sheet so fast without using the mouse, and so the way that I do this is to hold down the CONTROL key and hit PAGEDOWN to move to the right or PAGEUP to move to the left.
Great way to very quickly move through your worksheets, and so I always show this trick at the [ unintelligible – 00:49 ] he taught me a new one.
He said, okay, well, CONTROL+PAGEDOWN and PAGEUP is great for moving through the worksheets but what if you need to move screen folds of data to the right?
That’s ALT+PAGEDOWN.
So, here, I'm sitting in column A. I can see A through O on my screen.
When I press ALT+PAGEDOWN, it automatically moves me over to P, and now I can see through AD.
I hit ALT+PAGEDOWN again.
It moves one screen fold of data to the right.
ALT+PAGEUP of course moves one whole screen fold of data back to the left.
So, another great way to move very quickly through the spreadsheets.
Another cool thing.
If you have a mouse with a wheel on it, the scroll wheel, hold down the CONTROL key while you move the wheel and you can very quickly zoom in and zoom out.
Just try it.
You'll see which way.
Moving up, basically, will zoom in and then the other way will zoom out.
Alright.
So, those are just some quick tips.
Now, I have a question for you.
Usually, when I talk about the fill handle, I always show, you know, that it can't fill the number 1.
I grab the fill handle and drag and it just fills 1, 1, 1, 1, 1, and so if you hold down the CONTROL key, if you hold down the CONTROL key, well, then, Excel can actually extend the 1 into 2, 3, 4, 5, but then I had someone who said, well, look, I have this data here with these borders, and, normally, when I grab the fill handle and drag, it brings all of my borders down, and then I have to open this icon and choose FILL WITHOUT FORMATTING.
Great, but that fails when we use the number 1.
When we use the number 1, we hold down the CONTROL key in order to get us to 2, 3, 4, 5, 6.
It brings the borders down, and then, when we open this and change to FILL WITHOUT FORMATTING, it automatically changes back to 1s.
How frustrating is that?
So, write to me.
bill@mrexcel.com.
Let me know how you would fill that series without bringing the borders down.
Well, have a great weekend.
We'll see you next week for another netcast from Mr Excel.
Now, in the United States, we’re off today.
It's the 4th of July, Independence Day, but we're going to do a couple of…actually, several different things today, a couple of quick little tricks.
First of all, usually when I'm doing my seminar, I never cover this in the seminar, but people start to say, well, hey, how are you switching from sheet to sheet to sheet so fast without using the mouse, and so the way that I do this is to hold down the CONTROL key and hit PAGEDOWN to move to the right or PAGEUP to move to the left.
Great way to very quickly move through your worksheets, and so I always show this trick at the [ unintelligible – 00:49 ] he taught me a new one.
He said, okay, well, CONTROL+PAGEDOWN and PAGEUP is great for moving through the worksheets but what if you need to move screen folds of data to the right?
That’s ALT+PAGEDOWN.
So, here, I'm sitting in column A. I can see A through O on my screen.
When I press ALT+PAGEDOWN, it automatically moves me over to P, and now I can see through AD.
I hit ALT+PAGEDOWN again.
It moves one screen fold of data to the right.
ALT+PAGEUP of course moves one whole screen fold of data back to the left.
So, another great way to move very quickly through the spreadsheets.
Another cool thing.
If you have a mouse with a wheel on it, the scroll wheel, hold down the CONTROL key while you move the wheel and you can very quickly zoom in and zoom out.
Just try it.
You'll see which way.
Moving up, basically, will zoom in and then the other way will zoom out.
Alright.
So, those are just some quick tips.
Now, I have a question for you.
Usually, when I talk about the fill handle, I always show, you know, that it can't fill the number 1.
I grab the fill handle and drag and it just fills 1, 1, 1, 1, 1, and so if you hold down the CONTROL key, if you hold down the CONTROL key, well, then, Excel can actually extend the 1 into 2, 3, 4, 5, but then I had someone who said, well, look, I have this data here with these borders, and, normally, when I grab the fill handle and drag, it brings all of my borders down, and then I have to open this icon and choose FILL WITHOUT FORMATTING.
Great, but that fails when we use the number 1.
When we use the number 1, we hold down the CONTROL key in order to get us to 2, 3, 4, 5, 6.
It brings the borders down, and then, when we open this and change to FILL WITHOUT FORMATTING, it automatically changes back to 1s.
How frustrating is that?
So, write to me.
bill@mrexcel.com.
Let me know how you would fill that series without bringing the borders down.
Well, have a great weekend.
We'll see you next week for another netcast from Mr Excel.
