#How to link cells in excel for mac how to

To reference a cell range from another file, use square brackets to name the file, followed by a reference to the worksheet, and finally the cell range. To reference a cell range from another worksheet in the same file, name the worksheet before the cell range. This follows the same naming approach as listed above for individual cells. You can reference cell ranges in other worksheets and Excel spreadsheet files, too. You can use references to cell ranges in certain formulae.įor instance, finding the sum of cells C7 to C10 is easy-simply type =SUM(C7:C10), using a colon to connect the start (C7) and end (C10) cells in the range. It’s also possible to reference multiple cells in Excel, so long as they follow sequentially. Using =Sheet2!C7 *Sheet2!C8, you’d be able to multiply the data from cells C7 and C8 in worksheet Sheet2 from a file called Spreadsheet.xlsx. You’ll need to use square brackets to identify the file, name the worksheet it’s from, then use the cell reference. You can also reference cells from another Excel spreadsheet file. The formula =Sheet2!C7*Sheet2!C8 would multiply the data from cells C7 and C8 in a worksheet named Sheet2. The correct format for this is =Sheet2!C7. If you want to reference a cell from a different worksheet, you need to put the name of the worksheet before the cell, followed by an exclamation mark. =C7*C8 multiplies the data from C7 with the data from cell C8, for instance. To reference this cell in your active worksheet, type =C7 in a different cell, or use a formula containing that cell reference that combines multiple cell references together. Cell C7, for instance, is in the cell that intersects the third column (column C) and row 7. A spreadsheet in Excel is split into cells, which you can reference using letters for columns and numbers for rows. A map is split up into a grid, allowing you to pinpoint a specific location using the individual grid reference.Īn Excel spreadsheet works in a similar way. If you’ve ever used a map, you’ll be familiar with the idea of grid references.

#How to link cells in excel for mac how to

If you want to know how to cross-reference cells between Excel spreadsheets, here’s how. This is a useful feature that allows you to keep data separate and organized across different sheets and files.