MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Maintain Row Height In Numbers While Copying a Format?

Have created a 2 column format in Numbers with different row heights, i.e. R1=3.0, R2-R6=.8, R7=.2, R8=2.0, R9=1.2, R10=1.3.

Need to retain this row and column spacing throughout the document, i.e. R11 & R21=3.0,R20 & R30= 1.3.

Have tried copy, then paste and match style. Doesn’t seem to work.

Only option I see is to highlight each row and manually adjust height.

Thank you.
—–
Kazoo2U

Comments: 9 Responses to “How Do I Maintain Row Height In Numbers While Copying a Format?”

    5 months ago

    That information just won’t be include in the clipboard like that. You are copying the contents of the cells, not things like row height.

    Here’s what you can do. Leave the columns at the default height. But when you are done making the whole table, then select rows 11, 21, 31, 41, etc. Then in Format, Table, Tow $ Columns Size, set the heights of all of them to 3. Then select rows 12, 22, 32, 42 and set those heights, etc.

    I may have a better answer if I understood why you needed this. Rows in a table typically represent similar data, like records in a database. So it wouldn’t make sense to have rows be different heights. But often including the WHY when asking tech questions can help someone like me provide a better solution.

    Kazoo2U
    5 months ago

    Am trying to create a template for printing golf tournament scoresheets. 3″ line – school name, .8″ lines = players names, 1.2″ line – team score, 1.3″ line – coach’s name.

    5 months ago

    Kazoo2U: Ah, I see. This is one of those cases then when it DOES help to know why. I would do one table that has those rows. Make that one table perfect. Then copy and paste that table (the entire table) to fill out the sheet (assuming printing is your goal).

    Kazoo2U
    5 months ago

    When I do that, the row sizes all come out the same height. For example, in my first note, when I cut and paste the entire format with R1=3.0, all of the pasted row heights are 3.0 – r11=3, r12=3, etc.

    5 months ago

    Kazoo2U: Make sure you are copying and pasting the entire TABLE, not the rows in the table. Click on a cell in the table and then click on the circle at appears at the top left corner of the table to select the entire table. Then copy.

    Kazoo2U
    5 months ago

    Tried that – click on cell of original table, then click on circle in upper left corner where the axis meet. When I pasted, still got the same row height in pasted table. Do I need to press or while doing so?

    5 months ago

    Kazoo2U: You don’t need to do anything special. Just select the entire table, copy, then paste. When I try it it creates a duplicate of the table, with the row heights exactly as they are in the original. Maybe do a screen recording and share it so I can see where you may be going wrong?

    Kazoo2U
    5 months ago

    Would gladly send you a visual, but do not know how to make one.

    Kazoo2U
    5 months ago

    Should have waited to respond earlier. Have made a screen recording using QuickTime, but how do I upload it? Is this the way to upload?

    scoreboards.mov

Comments Closed.