Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel programming vba - linking cells data

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel programming vba - Linking 2 cells with data

excel programming vba - Linking 2 cells with data

ResolvedVersion Standard

Gurmit has attended:
Excel Advanced course

Linking 2 cells with data

I am trying to link 2 adjoining cells complete with data. I have tried via format cells > alignment but it is not working. Can anyone help ?

RE: Linking 2 cells with data

Hi Gurmit

What you would need to do is merge the two cells together, however, if you do this when both cells have data in them then not all the data is kept.

If you cut and paste the information from the second cell into the first cell, then select both cells and click on the merge button on the formatting toolbar (it is a white square with an 'a' and arrow pointing in either direction on it), this should allow you to merge (join) these two cells together and not lose any data in the process.

Amanda

RE: Linking 2 cells with data

Thanks Amanda,, however I cannot seem to find the A symbol with the 2 arrows. Can you tell me how pls ?

RE: Linking 2 cells with data

Hi Gurmit

The button is on the formatting toolbar - this is the toolbar that has the font, font size, bold, italics etc on it. If you can't find the button, you can also select the cells you wish to merge, then go to Format-Cells-Alignment, then check the Merge cells option near the bottom of the dialogue box and click OK.

Let me know if either of these things don't work for you.

Amanda

Excel tip:

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.