Clearing data

  • Thread starter Thread starter Tim Dolan
  • Start date Start date
T

Tim Dolan

I've got an excel spreadsheet with a column of 120 names.
each name has columns of stats that were entered weekly and have summary
columns.
The league ran for 22 weeks.
I would now like to use the spreadsheet again.
How can I remove the data entered weekly that utilized formulas? What I mean
is the weekly stats utilized weekly formulas and then the overall summary
uses formulas.
I can't just clear the data weekly because it wipes out the formulas. I can
only clear the columns that were entered for the weekly stats.
I hope I'm explaining this correctly.
Also, the spread sheet has "panes" , if that matters.
H-E-L-P please. Then I'll ask how to make a template.
 
First, do this against a copy of your workbook--just in case!

Select the range of cells that you want to clear. Be careful and don't include
headers (or other stuff you want to keep).

Now hit
Edit|Goto (or F5 or ctrl-g)
then click Special
then check the Constants option.

Now just the constants (no formulas) that were in that original selection are
selected.

Hit the delete key on the keyboard.

If it's not what you wanted, Edit|undo (or close without saving).
 
Thanks Dave,
I'll try it right now..
Tim fm Ct
Dave Peterson said:
First, do this against a copy of your workbook--just in case!

Select the range of cells that you want to clear. Be careful and don't
include
headers (or other stuff you want to keep).

Now hit
Edit|Goto (or F5 or ctrl-g)
then click Special
then check the Constants option.

Now just the constants (no formulas) that were in that original selection
are
selected.

Hit the delete key on the keyboard.

If it's not what you wanted, Edit|undo (or close without saving).
Click to expand...
 
Back
Top