clearing data but not formulas

  • Thread starter Thread starter pingu_632
  • Start date Start date
P

pingu_632

I'm hoping someone can help me. I have a form where I enter several
marks for a student and then a bunch of calculations are made. I want
to be able to clear that students marks and enter another students
marks. Other than using "save as" and opening and closing the file,
is there a way to clear the data, but leave the formulas and
formatting intact?
 
You could select the cells where you enter the data and clear those. RIght
click and CLEAR CONTENTS.
 
Just to add to Barb's suggestion.

Do this one time:
Select the cells that are used for input (use click, shift-ctrl-click and
ctrl-click to include all those cells).
Then give that selected range a nice name by typing it in the Name box (to the
left of the formula bar) and remember to hit enter after you finish typing that
name. (I called mine myInput.)

Now when you want to clear that range, you can just
edit|goto (or ctrl-g or F5)
type: myinput
and hit enter
then hit the delete key on the keyboard

You can also just choose the name from that namebox dropdown arrow.
 
F5>Special>Constants.

Uncheck what you don't want to select and OK.

Edit>Delete


Gord Dibben MS Excel MVP
 
Thank you. The other users of this form subscribe to the KISS rule,
naming the range will be the simplest solution for them.
 
Back
Top