How to Join Two Columns in Excel

Save

Microsoft Excel is a program included in the Microsoft Office suite. Microsoft Excel is designed to work with spreadsheets consisting of columns and rows. Excel allows you to perform various operations with spreadsheet data as well as make data graphs. Joining or merging columns is an operation that aims to combine two or more Excel columns in one.

  • Click the "Start" button in Windows XP/Vista and open "All Programs."

  • Click on the folder "Microsoft Office" and then "Microsoft Office Excel" to launch the program.

  • Press either "Ctrl-N" to create a new Excel document or "Ctrl-O" to browse your computer and open an existing one.

  • Holding the left mouse button and select columns you need to merge.

  • In Microsoft Excel 2007:
    Click the menu "Home" and click "Merge Cells" in the field "Alignment."
    In Microsoft Excel 2003/XP:
    Click the menu "Format" and "Cells." Select the tab "Alignment" and check the box "Merge Cells." Click "OK."

References

  • "Microsoft Office 2007 Simplified"; Sherry Willard Kinkoph; 2007
  • "Excel 2003 Bible," John Walkenbach, September 2003.
Promoted By Zergnet

Comments

You May Also Like

  • How to Combine Columns of Data in MS Excel

    An Excel spreadsheet contains columns of data that you need to combine using an operation to generate an additional column. You can...

  • How to Merge Multiple Columns Into One Column

    Microsoft Excel and Google Spreadsheets are two programs that allow you to sort information into blocks of data called columns. Columns allow...

  • How to Merge Columns

    Merging columns in Excel, Open Office or Google Docs is a simple process. It is important to determine if the columns need...

  • How to Merge Two Columns

    A table is a grid with rows and columns of cells. The cells may include text, graphics or other objects you want...

  • How to Merge Two Columns in Excel 2007

    Merging data in Excel is an example of some of the powerful features Excel offers. Merging or concatenating can be done using...

  • How to Merge Columns From Two Tables

    Excel 2010 comes with a number of tools and wizards to help you manipulate your worksheet in numerous ways, but occasionally you...

  • How to Combine Columns

    Concatenation in Excel lets you combine data from multiple cells into one cell. This feature is helpful when you need to merge...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!