Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2005

Tip: Looking for answers? Try searching our database.

Grouping cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
buffboo - 05 Sep 2005 19:20 GMT
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?
Dave Peterson - 05 Sep 2005 21:22 GMT
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?

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

Signature

Dave Peterson

Cutter - 05 Sep 2005 22:02 GMT
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.

Signature

Cutter

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.