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.

📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025

Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >

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

Why can't I use the copy/paste style utility

Hello

I have a spreadsheet with about 300 rows and at least 4 columns. It is an overview of vegetables and fruits I use(d) to grow in my garden. I want to insert a picture in each row, so I pasted a picture in the first cell. Unfortunately Numbers doesn't re-format the row and column so that the picture will fit, so I had to do this by hand. I selected this cell, copy the style and tried to paste the style to the other cells (downwards). Nothing happened.


What goes wrong?


User uploaded file


Thanks in advance for your help.

Hans

iMac (27-inch Mid 2010), OS X El Capitan (10.11.1)

Posted on Aug 4, 2016 10:23 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 4, 2016 11:37 AM

Hi Hans,


When you paste an image into a Numbers Table cell, the image is pasted as "Image Fill", and, by default, is scaled to fit the current size of the cell.


"Fill" is part of the Style of that cell, and is included when you Copy Style. Row Height and Column Width, which together define the size of the cell, are not part of that cell's Style properties, and are not copied or pasted when you Copy Style or Paste Style.


In the table below, your image (a screen shot from this page, so lower resolution than your original) was pasted into A1. The cell was then selected, its Style copied (option-command-C), then the Style was pasted (option-command-V) into each of the cells along a diagonal. Column and Row widths and heights were adjusted by dragging the bars dividing the Column and Row name labels in the reference tab bars above and left of the table, giving the result shown.

User uploaded file

The Cell Format Inspector offers five choices of fitting Image fill into a cell. Scale to Fit is the default, and constrains the image to a size that fills the cell in one direction, but may leave gaps in the other direction. In the example below, most copies of the image are constrained by the width of the cell thy are filling. A few, mostly on the top row, are constained by the row's height.

User uploaded file

Row and Column size may be set by dragging, as I did above, or in the Table Inspector.


Regards,

Barry

3 replies
Question marked as Top-ranking reply

Aug 4, 2016 11:37 AM in response to hanyvo

Hi Hans,


When you paste an image into a Numbers Table cell, the image is pasted as "Image Fill", and, by default, is scaled to fit the current size of the cell.


"Fill" is part of the Style of that cell, and is included when you Copy Style. Row Height and Column Width, which together define the size of the cell, are not part of that cell's Style properties, and are not copied or pasted when you Copy Style or Paste Style.


In the table below, your image (a screen shot from this page, so lower resolution than your original) was pasted into A1. The cell was then selected, its Style copied (option-command-C), then the Style was pasted (option-command-V) into each of the cells along a diagonal. Column and Row widths and heights were adjusted by dragging the bars dividing the Column and Row name labels in the reference tab bars above and left of the table, giving the result shown.

User uploaded file

The Cell Format Inspector offers five choices of fitting Image fill into a cell. Scale to Fit is the default, and constrains the image to a size that fills the cell in one direction, but may leave gaps in the other direction. In the example below, most copies of the image are constrained by the width of the cell thy are filling. A few, mostly on the top row, are constained by the row's height.

User uploaded file

Row and Column size may be set by dragging, as I did above, or in the Table Inspector.


Regards,

Barry

Why can't I use the copy/paste style utility

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