How do you tie two columns together?

How do you tie two columns together?

2. How to Combine Excel Columns With the CONCAT Function

1. Click the cell where you want the combined data to go.
2. Type =CONCAT(
3. Click the first cell you want to combine.
4. Type ,
5. Click the second cell you want to combine.
6. Type )
7. Press the Enter key.

How do I freeze the first two columns in Excel?

Freeze columns and rows

1. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
2. Select View > Freeze Panes > Freeze Panes.

How do you combine two lists in Excel?

Excel combines the two lists into a single list….Excel: Use Consolidation to Combine Two Lists

1. Move the cell pointer to a blank area of the worksheet.
2. Select Data, Consolidate.
3. Make sure that both boxes under Use Labels In are checked.
4. Put the cell pointer in the Reference field.

How do I lock certain columns in Excel?

Press the Keyboard Shortcut Ctrl + A to select all the cells of the sheet. Right click and choose Format cells. Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect.

How do I lock rows together in Excel?

To do this, use Excel’s Freeze Panes function. If you want to freeze just one row, one column or both, click the View tab, then Freeze Panes. Click either Freeze First Column or Freeze First Row to freeze the appropriate section of your data. If you want to freeze both a row and a column, use both options.

How do I merge two cells in Excel without losing data?

How to merge cells in Excel without losing data

1. Select all the cells you want to combine.
2. Make the column wide enough to fit the contents of all cells.
3. On the Home tab, in the Editing group, click Fill > Justify.
4. Click Merge and Center or Merge Cells, depending on whether you want the merged text to be centered or not.

How do you concatenate?

There are two ways to do this:

1. Add double quotation marks with a space between them ” “. For example: =CONCATENATE(“Hello”, ” “, “World!”).
2. Add a space after the Text argument. For example: =CONCATENATE(“Hello “, “World!”). The string “Hello ” has an extra space added.

How do I freeze the top 2 rows in Excel 2021?

How To Freeze the Top Row in Excel

1. Open the Worksheet you want to work on.
2. Select the “View” tab and navigate to “Freeze Panes.”
3. Select “Freeze Top Row.”

How do I lock the top 2 rows in Excel?

To freeze rows:

1. Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3.
2. Click the View tab on the Ribbon.
3. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
4. The rows will be frozen in place, as indicated by the gray line.

Can you lock cells in Excel for editing?

To lock cells for editing: On the Review tab > Protect Sheet. Type a password, and make sure that Protect worksheet and contents of locked cells is selected. Click OK.