J
JHI
How do I remove the data without removing the formulas?
Thanks.
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Ed Ferrero
A
*alan*
That doesn't seem to work. Is there perhaps another step that needs to be
taken?
taken?
E
Ed Ferrero
Hi Alan,
Works for me (in Excel 2003 and 2007), what version of Excel do you use?
Ed Ferrero
Works for me (in Excel 2003 and 2007), what version of Excel do you use?
Ed Ferrero
D
David McRitchie
Like make a selection first.
A
*alan*
Aha --- now it works. My problem had not been a failure to make a
selection, but rather that, having seen that my selection of the formula
cell had moved to the two prior cells, I had RE-selected the formula cell
before hitting Delete. It works.
But --- now I have another question.
Is there any particular advantage doing it as Ferrero had suggested, versus
using fewer keystrokes and mouse-clicks and just selecting the first two
cells and hitting Delete?
selection, but rather that, having seen that my selection of the formula
cell had moved to the two prior cells, I had RE-selected the formula cell
before hitting Delete. It works.
But --- now I have another question.
Is there any particular advantage doing it as Ferrero had suggested, versus
using fewer keystrokes and mouse-clicks and just selecting the first two
cells and hitting Delete?
E
Ed Ferrero
If you only have two cells with constants that you want to delete, then go
ahead and select them manually. If you have 200 cells scattered all over the
worksheet...
Ed Ferrero
ahead and select them manually. If you have 200 cells scattered all over the
worksheet...
Ed Ferrero
D
David McRitchie
Hi Alan,
I think your question is a bit too ambiguous to answer that. If it is only
two cells
you want to delete than you would select them.
Ed is giving you a means to clearing a lot of cells in a selection.
Don't know if this would be of interest to you or not, but it provides
a means of inserting rows the same as the row of the active cell below
that row, retaining formulas and deleting constants, as you might want
for a check book balance
Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
I think your question is a bit too ambiguous to answer that. If it is only
two cells
you want to delete than you would select them.
Ed is giving you a means to clearing a lot of cells in a selection.
Don't know if this would be of interest to you or not, but it provides
a means of inserting rows the same as the row of the active cell below
that row, retaining formulas and deleting constants, as you might want
for a check book balance
Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
A
*alan*
Mr McRitchie and Mr Ferrero, thank you both for explaining that.
Yes, I do see the advantage in a more complex workbook. It finally makes
sense to me.
And thanks Mr McRitchie for the info on the row insertion.
Yes, I do see the advantage in a more complex workbook. It finally makes
sense to me.
And thanks Mr McRitchie for the info on the row insertion.