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.

"(E-Mail Removed)" wrote:

> 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?
>
>

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.


(E-Mail Removed) wrote:
>
> 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?

--

Dave Peterson

F5>Special>Constants.

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

Edit>Delete


Gord Dibben MS Excel MVP

On 17 May 2007 22:01:50 -0700, (E-Mail Removed) wrote:

>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?

Thank you. The other users of this form subscribe to the KISS rule,
naming the range will be the simplest solution for them.
>
> 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.
>
> pingu_...@hotmail.com wrote:
>
> > 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?
>
> --
>
> Dave Peterson