Donna from Colorado asks how to clear all of the input cells from a model. In today's Where Is It Wednesday Episode 868, we take a look at how to select only the numeric constants. Also - following up on 858 - Copy as Picture, 860 Resizing Header Logo, 863 Protect Sheet.
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, thanks to George Wood for that great "Where Is It Wednesday" theme.
I have a question today.
Donna from Colorado asked this in a seminar, said she has a model that she needs people to fill in the input cells; and then when she was done, she would like to be able to clear out all the input cells, but keep all of the formulas and labels there.
Well, there is a way to do this.
Now, let's just take a quick look.
I'll press Ctrl and the Grave Accent (Ctrl+`) and you'll see that, basically, all the orange cells are the input cells and everything else there is a formula.
So, I'll press that again, and what we're going to do is, we're going to select this data and, basically, use Go to Special.
Now, you can always use Ctrl+G and then click Special, or now, in Excel 2007, Find and Select, and that's right there-- Go to Special.
And we're going to say that we want the "Constants", but only the "Numbers".
So we don't need any Constants that are Text, Logical, or Errors.
And you'll see that that now selects all of the cells that are input cells.
When I press delete, it will instantly delete all of those cells for us.
So, great way to go.
Hey, also, let's go back and talk about a few pods over the last few weeks.
Back in Episode 858, we talked about Copy as Picture, and I lamented that that was very tough to find.
Well, this one confuses even me.
Copy as Picture is actually not under Copy, but under the Paste icon; and then As Picture; Copy as Picture.
Go figure that one.
In Episode 860, we talked about a header logo-- putting an image up in the header-- and whether it shrinks as you add more columns.
Well, that is now a feature in Excel 2007.
So if you go into Page Setup, under Header/Footer, "Scale with document"-- you can turn this on and turn this off.
So, you have control in 2007, whether or not that image size changes.
In 2003, you're just simply out of luck.
And then, last week, Episode 863, I talked about Protect Sheet, and kind of wondered why it was on the Home, Format, Protect Sheet.
Someone pointed out it is much more obvious back on the Review tab, where we have Protect Sheet.
So, it's in both places; both on the Home tab, where all the important stuff is supposed to be; and back on the Review tab, where you'll find it.
So, there you have it, a couple of different tricks today: How to clear all of the input cells, and then following up on a couple of issues over the last couple of weeks.
Want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
Well, thanks to George Wood for that great "Where Is It Wednesday" theme.
I have a question today.
Donna from Colorado asked this in a seminar, said she has a model that she needs people to fill in the input cells; and then when she was done, she would like to be able to clear out all the input cells, but keep all of the formulas and labels there.
Well, there is a way to do this.
Now, let's just take a quick look.
I'll press Ctrl and the Grave Accent (Ctrl+`) and you'll see that, basically, all the orange cells are the input cells and everything else there is a formula.
So, I'll press that again, and what we're going to do is, we're going to select this data and, basically, use Go to Special.
Now, you can always use Ctrl+G and then click Special, or now, in Excel 2007, Find and Select, and that's right there-- Go to Special.
And we're going to say that we want the "Constants", but only the "Numbers".
So we don't need any Constants that are Text, Logical, or Errors.
And you'll see that that now selects all of the cells that are input cells.
When I press delete, it will instantly delete all of those cells for us.
So, great way to go.
Hey, also, let's go back and talk about a few pods over the last few weeks.
Back in Episode 858, we talked about Copy as Picture, and I lamented that that was very tough to find.
Well, this one confuses even me.
Copy as Picture is actually not under Copy, but under the Paste icon; and then As Picture; Copy as Picture.
Go figure that one.
In Episode 860, we talked about a header logo-- putting an image up in the header-- and whether it shrinks as you add more columns.
Well, that is now a feature in Excel 2007.
So if you go into Page Setup, under Header/Footer, "Scale with document"-- you can turn this on and turn this off.
So, you have control in 2007, whether or not that image size changes.
In 2003, you're just simply out of luck.
And then, last week, Episode 863, I talked about Protect Sheet, and kind of wondered why it was on the Home, Format, Protect Sheet.
Someone pointed out it is much more obvious back on the Review tab, where we have Protect Sheet.
So, it's in both places; both on the Home tab, where all the important stuff is supposed to be; and back on the Review tab, where you'll find it.
So, there you have it, a couple of different tricks today: How to clear all of the input cells, and then following up on a couple of issues over the last couple of weeks.
Want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
