Grouping cells

B

buffboo

I have a document of several columns and rows. I need to have column B,
D, E and F grouped somehow for each row so that if we delete the info
in column B, column D,E,F automatically delete. Does anyone know how to
do this?
 
D

Dave Peterson

I don't think that there's a way to insure it.

But you could give the users a macro that did the deleting the way you want. If
you make that macro easy to use, then maybe they'll use that instead of the
built in methods.

When you delete info in column B, do you want to delete the whole row or do you
just shift the cells up (for B and D:F)?

Or do you mean clear contents of D:F when you clear the contents in column B?
 
C

Cutter

Select the columns you want by first selecting Column B. Then hold down
the Ctrl key while you select the other columns.
Now with the 4 columns highlighted type a name in the Name Box which
appears above Column A and the row headers.
Hit the Enter key after you've typed the name. (make sure you typed a
valid name - you can't use spaces for example)

Now when you want to delete the data from your 4 columns you go to the
drop down arrow on the Name Box, select the name you gave the range and
then hit the Delete key.
 
Top