I have a spreadsheet where I am merging First Name (column A)and Last Name (Column B) using format = A & " " & B
This works but How to I apply this to all 100 + rows in my spreadsheet in one click so I don't have to do individual rows at a time?
Thank you.
MacBook Pro 15″, macOS 12.7
There are two ways to AutoFill.
Select the first cell (i.e. C2 in your table) and look for the little handle that appears at the bottom of the cell.
Click this and drag down to copy the formula down the column - all the cells you drag over will get the formula.
- or -
Select the first cell
Hold the shift key and click the last cell in the column
Choose the Table -> AutoFill Cells -> Auto Fill Down menu item:
There are two ways to AutoFill.
Select the first cell (i.e. C2 in your table) and look for the little handle that appears at the bottom of the cell.
Click this and drag down to copy the formula down the column - all the cells you drag over will get the formula.
- or -
Select the first cell
Hold the shift key and click the last cell in the column
Choose the Table -> AutoFill Cells -> Auto Fill Down menu item:
You can drag the formula down from one cell to another by using autofill.
Here’s how you can do that:
Autofill cells in Numbers on Mac - Apple Support
Assuming you are on the Mac and that your formula is in C2 then you call also do this:
SG
Merge Column A with Column B in Numbers - highlight all
