How to combine multiple spreadsheets into one using numbers
I have 3 sheets , all have similar data but each one has two columns I need added to the first . how can I do it
The grid of cells is called a table in Numbers. Sheets are like a blank canvas which contain tables, text boxes, shapes, etc.. Often there is only one table per sheet, which I will assume is what you have.
Assuming the two columns are side-by-side in the table and you want to copy the data to the "receiving' table, not reference it from the other table,
- In the "receiving" table, insert two new columns where you want the new columns to be
- Go to the "donor" table. Select the two columns you want to copy. One way is to click on the column letter for the left column then shift-click the column letter for the right column.
- Copy (Command C)
- Got to the receiving table. Select the top cell in the left new column
- Paste (Cmd V). All the data should have been copied to the table.
If it doesn't do what you wanted, use Undo (Cmd Z).
If there were formulas in those copied rows, any references that were to other cells within the table will become references to cells in the "receiving" table (or error triangles if that was not possible).