No Links were listed yet. Go ahead and share!
Alright, welcome back to Mr.excelnetcast. I’m Bill.
Great question sent by Jerry. Jerry has a model has been built, there’s a lot of formulas in the model and then some input cells. Jerry wants to make a copy of that model for next month and wants to clear out input cells but not the formula cells. Alright, first of all to copy the sheet you can right click on the tab, choose over copy, but the faster way to go is to hold down control and drag that sheet to a new spot. That will make a copy, of course you might want to rename it to be next year or something like that.
Now the hard part is clearing out all the numeric input cells, but keeping all of the formula cells. Here’s how we are going to do that. Now, we’re just, choose a cell as what you do, control A, to select all cells you could of course do that by clicking this box above in the left of A1, and then I’m going to use control G to display the “ Go to dialogue box” and alt S to choose special.
Now in here, I want to say that I want to choose all of the constants, but only the constants that are numbers. So I'm going to uncheck text, logicals and errors and click okay. Now it has very settle here in Excel 2007 to see which items are selected but in fact all of the input cells are now selected. I have a couple of options; I could press the “delete” key to clear those or I just want to zero them all out, I’m going to zero and control enter. Also while that is selected, it might be a good time to use the cell style.
Let’s define those input cells in Excel 2007. They have cell styles built in for input, calculation and so on, so let’s go ahead and choose input. That way people know where they have to enter the data. Great little feature built in the Excel 2007 there, but not central Jerry’s question. Jerry’s question is how to clear up all the input cells, again Control A to select your inning, Control G for Go To, Alt S for Special, and then choose formulas uncheck the other rows and you’ve gotten all the numeric input cells selected.
And here I want to thank you for stopping by and see you next time for another net cast from Mr. Excel.
Transcription by:
Scribe4you Transcription Services