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?
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...
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
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
