User level: Level 1 (4 points)How to name a range of number likeA2:C4 with Apple numbers on
[Re-Titled by Moderator]
Original Title: Range
Posted on Oct 4, 2026 2:07 PM
User level: Level 7 (26,777 points)Oct 4, 2026 4:55 PM in response to TransDog44
Sorry, you can't: the Numbers app from Apple does not support named ranges like Microsoft Excel does.
User level: Level 7 (22,545 points)Oct 4, 2026 6:44 PM in response to TransDog44
Hi Transdog,
A Numbers table is equivalent to a named range in Excel.
Excel sheets are "oceans" of cells, with small "Islands" of data here and there.
A Numbers sheet can hold several small tables, each with a purpose.
What are you trying to do?
Regards,
Ian.
User level: Level 1 (14 points)Oct 4, 2026 6:50 PM in response to TransDog44
Apple Numbers, A2:C4 is already the correct way to refer to a rectangular group of cells: it means everything from column A, row 2 through column C, row 4. You use it inside a formula, such as =Sum(A2:C4) which adds the value 3by3 from a2-c4
Originally posted at discussions.apple.com/thread/256370444