You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
Assuming you are on the Mac and that your formula is in C2 then you call also do this:
SG
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
Merge Column A with Column B in Numbers - highlight all
