I'm pretty sure the answer's no, but...

%3CLINGO-SUB%20id%3D%22lingo-sub-2620163%22%20slang%3D%22en-US%22%3EI'm%20pretty%20sure%20the%20answer's%20no%2C%20but...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2620163%22%20slang%3D%22en-US%22%3E%3CP%3E...is%20there%20a%20way%20to%20%22glue%22%20cells%20in%20Excel%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20three%20cells%20(all%20containing%20independent%2C%20unrelated%20values)%20that%20you%20often%20copy%20and%20paste%20as%20a%20group%2C%20just%20from%20one%20area%20of%20a%20spreadsheet%20to%20another%2C%20is%20there%20a%20way%20to%20glue%20them%20so%20that%20you%20only%20have%20to%20click%20once--in%20any%20area%20of%20the%20three%20cells--to%20select%20all%20three%20and%20move%20or%20copy%20them%20as%20a%20group%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20appreciated%2C%3C%2FP%3E%3CP%3EAlicia%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2620163%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2620494%22%20slang%3D%22en-US%22%3ERe%3A%20I'm%20pretty%20sure%20the%20answer's%20no%2C%20but...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2620494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1122263%22%20target%3D%22_blank%22%3E%40Alicia645%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20you%20guessed%2C%20tha%20answer%20is%20no.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2622567%22%20slang%3D%22en-US%22%3ERe%3A%20I'm%20pretty%20sure%20the%20answer's%20no%2C%20but...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2622567%22%20slang%3D%22en-US%22%3EI%20hate%20being%20right.%3CBR%20%2F%3EThanks%20tho%2C%3CBR%20%2F%3EA.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2622606%22%20slang%3D%22en-US%22%3ERe%3A%20I'm%20pretty%20sure%20the%20answer's%20no%2C%20but...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2622606%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1122263%22%20target%3D%22_blank%22%3E%40Alicia645%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20a%20vba%20solution%20is%20acceptable%2C%20then%20I%20think%20you%20may%20be%20able%20to%20do%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20select%20the%20cells%20and%20give%20them%20a%20name%20(say%20%22MyGroup%22%2C%20for%20example)%2C%20then%20right%20click%20on%20your%20worksheet%2C%20click%20view%20code%2C%20and%20paste%20this%20into%20the%20code%20window%2C%26nbsp%3B%20then%20it%20should%20select%20the%20group%20of%20cells%20whenever%20you%20select%20one%20of%20them.%20Just%20change%20the%20range%20name%20in%20the%20code%20to%20whatever%20you%20decide%20to%20use.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EPrivate%20Sub%20Worksheet_SelectionChange(ByVal%20Target%20As%20Range)%0A%20%20%20%20%20If%20Not%20Intersect(Target%2C%20Me.Range(%22MyGroup%22))%20Is%20Nothing%20Then%0A%20%20%20%20%20%20%20%20%20%20Application.EnableEvents%20%3D%20False%0A%20%20%20%20%20%20%20%20%20%20Me.Range(%22MyGroup%22).Select%0A%20%20%20%20%20%20%20%20%20%20Application.EnableEvents%20%3D%20True%0A%20%20%20%20%20End%20If%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

...is there a way to "glue" cells in Excel? 

 

If you have three cells (all containing independent, unrelated values) that you often copy and paste as a group, just from one area of a spreadsheet to another, is there a way to glue them so that you only have to click once--in any area of the three cells--to select all three and move or copy them as a group? 

 

Any advice appreciated,

Alicia

 

 

5 Replies

@Alicia645 

As you guessed, tha answer is no.

I hate being right.
Thanks tho,
A.

@Alicia645 

 

If a vba solution is acceptable, then I think you may be able to do that.

 

If you select the cells and give them a name (say "MyGroup", for example), then right click on your worksheet, click view code, and paste this into the code window,  then it should select the group of cells whenever you select one of them. Just change the range name in the code to whatever you decide to use.

 

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
     If Not Intersect(Target, Me.Range("MyGroup")) Is Nothing Then
          Application.EnableEvents = False
          Me.Range("MyGroup").Select
          Application.EnableEvents = True
     End If
End Sub

 

Hi JMB17,
This is a little bit above my pay grade but I think I have someone who can help me with it. I have a couple of questions first...

If the cells I am grouping have different values (text on the left and time on the right), will each cell retain its original properties, i.e., EXCEL will recognize the number on the right as an expression of hours and minutes and be able to perform calculations as usual, as long as I have previously chosen that number format for that cell?

I would have to choose a unique range name for each pair of cells, wouldn't I?

Thanks for your help!
A.

Oh, holy (insert dirty word)! I did it myself! It works!
I didn't even have to call any of my kids to help me!
Thanks so much!
A.