Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

how can I inherit format when I create a new row or column in Apple Numbers?

how can I inherit format when I create a new row or column in Apple Numbers? For example, if I have a column of dates and create a new row, how can I require the new row to inherit the date format above it?

iMac 27″, macOS 10.15

Posted on Aug 7, 2021 6:31 PM

Reply
4 replies

Aug 7, 2021 9:40 PM in response to LMHudson

The cells in newly created row generally take on the formats of the cells in the row immediately above, automatically.


Are you experiencing something different? If so a screenshot would help (shift-command-4, select area, release, and in a new post here insert the image using the icon that looks like mountains).


SG

Aug 8, 2021 11:03 AM in response to LMHudson

I am guessing that the difference between what you are seeing and what SGIII is showing is the way the cell format is set. If you type a date into a blank cell then go look at the cell format, it will be "automatic" with settings for date and time that match what you typed. That format will not carry down into a new row, the new row will be "automatic" with no date & time settings. You need to change the format to Date&Time for it to carry down (or change either the date or time setting and Numbers will change the format to Date&Time for you).

how can I inherit format when I create a new row or column in Apple Numbers?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.