Skip navigation

copy and paste cell formatting?

716 Views 11 Replies Latest reply: Oct 17, 2013 5:55 PM by Wayne Contello RSS
hotwheels 22 Level 1 Level 1 (0 points)
Currently Being Moderated
Oct 17, 2013 11:23 AM

i am slowly learning how to use numbers but it is a big battle coming from excel. in some cases it appears that very straightforward items that are needed are not implemented and in other cases it appear that they are and i am using an incorrect pickorder or trying the wrong pulldown or wrong inspector area.

 

as a for instance on the latter - there is (apparently) no option to have the cell outlines default to black all the time? i mean, when i want it blank i pulldown to "all inside" and select none but when i want an outline i constantly have to select the black color because it defaults to grey or white or something? so even if i select all inside and "thin" i /still/ have to select black for the color? this seems blindingly dumb but maybe i am using it wrong. anyway, i am digressing...

 

i need to add a whole series of underlines that are line thickness of 3 and i am (currently) selecting the set of columns in the row that i need this in (i don't need it in the first row) and then i am running a pulldown as described above (1. bottom 2. line 3. 3 pixels and - i forget if i have to select black as the fourth selection) for each set of underlnes and i am wondering if there is a way to select this existing format and to paste it by - say - selecting the first column in the row that i need this in and just PASTING it in.

 

i am searching in the help and i am not finding this.

 

TIA

MacBook Pro, OS X Mountain Lion (10.8.1)
  • Wayne Contello Level 6 Level 6 (12,570 points)
    Currently Being Moderated
    Oct 17, 2013 11:35 AM (in response to hotwheels 22)

    You can copy style (including cell borders) using the menu items "Format > Copy Style" and "Format > Paste Style"

     

    Screen Shot 2013-10-17 at 1.33.13 PM.png

     

     

    I think the cell border formatting controls are a pain so I avoid using them.  If I have to do this often I would make a table with the the selection I want the store that in a template and cpy and paste style from there.

  • Jerrold Green1 Level 7 Level 7 (28,120 points)
    Currently Being Moderated
    Oct 17, 2013 11:39 AM (in response to hotwheels 22)

    HW,

     

    Create a Table Style from a table that you have previously set to have all black borders. Once you have done that you can quickly change any table's borders to black, and if you want to change the weight of a particular border in that table, it will already be black and all you will have to do is change the line weight.

     

    Jerry

  • Wayne Contello Level 6 Level 6 (12,570 points)
    Currently Being Moderated
    Oct 17, 2013 11:49 AM (in response to hotwheels 22)

    The only way I can get the menu items "Format > Copy Style" and "Format > Paste Style" to be greyed out is to have not table or cells selected.

     

    Cell A4 selected:

    Screen Shot 2013-10-17 at 1.48.25 PM.png

     

    Nothing selected:

    Screen Shot 2013-10-17 at 1.48.32 PM.png

  • Wayne Contello Level 6 Level 6 (12,570 points)
    Currently Being Moderated
    Oct 17, 2013 12:33 PM (in response to hotwheels 22)

    HW,

     

    I suggest refering to the built-in help for Numbers.  First select the menu item "Help > Numbers Help":

     

    Screen Shot 2013-10-17 at 2.31.33 PM.png

     

    Then in the help window use the search tool and enter "border" in the serch field at the top right:

    Screen Shot 2013-10-17 at 2.31.39 PM.png

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Oct 17, 2013 5:43 PM (in response to hotwheels 22)

    "6A /should/ say "To set a well color default so you don't have to ALWAYS change a color EVERYTIME you have to use the Border Style functionality, right click on the well and select a color and click on DEFAULT. this way you can have a default color for your Border Styles."

     

    Any statement that includes the word "should" is directed to the wrong audience here. Apple can make changes to the application; users generally cannot.

     

    Use the Provide Numbers Feedback item in the Numbers menu in Numbers to send your feature request directly to Apple.

     

    Regards,

    Barry

  • Wayne Contello Level 6 Level 6 (12,570 points)
    Currently Being Moderated
    Oct 17, 2013 5:55 PM (in response to hotwheels 22)

    HW,

     

    I was not being funny or cute.  The question of borders in Numbers has been covered many times in the forums and it simply doesn't work they way you, or others, want.  The people,like me, Jerry, Barry, Ian, Badunit, are all fellow users and have no ability whatsoever to affect change with the Numbers application.

     

    Generally we try to provide something, when an elegant solution, a work around, or a cludge to solve a problem with in the constraint that we cannot make changes to Numbers since we are not the developers, nor do we have any more access than you do.

     

    I hope you can understand this point. Here is a description af all the steps to change the border:

    https://discussions.apple.com/message/22565277#22565277

     

    you can use the information or not but the fact is there is no way, other than what has previously been discussed, to save a default as you want.  Barry has shown you the way to provide feedback.  I hope you use it.

     

    Wayne out for this thread.

     

    Best regards,

    Wayne

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.