Medking Posted September 23, 2009 Share Posted September 23, 2009 Hi everyone, I'm used to Excel, and so in numbers I want to make many rows have a bottom border of exactly the same thickness, dotted line. However, I can't seem to make it so that I can copy that border and apply it to the other rows. Instead I'm having to select the rows manually and apply a new border for each, which is taking an absolute @$$ load of time. Any tips on how to do this faster? I know I used to do something in Excel which would make all of the rows from thereonwards have that border style... And if that didn't work I could always draw the borders... Thanks, Medking Link to comment Share on other sites More sharing options...
Phantom Helix Posted September 23, 2009 Share Posted September 23, 2009 this might help you, this site is pretty good http://www.numberstemplates.com/category/templates/ Link to comment Share on other sites More sharing options...
Medking Posted September 23, 2009 Author Share Posted September 23, 2009 That site is fine if you know what you're looking for. I don't. I'm coming from Excel 2007, and although there was a claim that I read somewhere saying that Numbers is more powerful than Excel, I'm not seeing it so far. It seems as if all of the functions are more limited..? Medking Link to comment Share on other sites More sharing options...
Elliott Posted September 23, 2009 Share Posted September 23, 2009 It's right in the Inspector panel, under the "Table" tab. Just select all the rows you want the bottom border on, click the button I circled, and do all the styling in the tools right below the button. Every new row you create after that should have the same style applied (I tested it out and it works). Link to comment Share on other sites More sharing options...
Arpit Posted September 23, 2009 Share Posted September 23, 2009 numbers, by no means, is a replacement to excel. at best it complements it. my biggest gripe with it is that when entering a formula which includes reference cells, i can't navigate with my keyboard, i have to resort to the mouse. Link to comment Share on other sites More sharing options...
Medking Posted September 23, 2009 Author Share Posted September 23, 2009 Ok, I'm starting to get the hang of this actually. I've watched some of the tutorials on Apple's site, and I'm quite liking how you can manage many different tables upon a blank canvas. Very useful! @Elliot: How did you get every row after that to have the same style? Do you mean as in you made a table (1x1) and then dragged it out? Because yea, I think it works when you do that. Thanks, Medking Link to comment Share on other sites More sharing options...
Elliott Posted September 23, 2009 Share Posted September 23, 2009 @Elliot: How did you get every row after that to have the same style? Do you mean as in you made a table (1x1) and then dragged it out? Because yea, I think it works when you do that. Thanks, Medking I didn't do a 1x1 table, but I did style the very last row of the table (along with all the others). Same premise would apply if you started with a 1x1 and dragged it out (or hit Return). Link to comment Share on other sites More sharing options...
Medking Posted September 23, 2009 Author Share Posted September 23, 2009 OK great, that's fantastic. I'm playing around with the software now, I find the Apple Tutorials incredibly helpful actually. Can't remember ever using a MSFT tutorial to save my soul. Haha. Link to comment Share on other sites More sharing options...
PyX Posted September 25, 2009 Share Posted September 25, 2009 OK great, that's fantastic. I'm playing around with the software now, I find the Apple Tutorials incredibly helpful actually. Can't remember ever using a MSFT tutorial to save my soul. Haha. Well yeah, Apple's iWork suite is a lot less powerful than Office, but in Office they really don't help you in finding what you want. The best thing they did recently was the Ribbon IMO, but it seems to have mixed up everybody, so I don't know... One of the most useful (but off-topic) features in iWork is the "function dictionary" which contains every function in Numbers as well as an awesome description. This can also be used as a help tutorial for Excel :) Link to comment Share on other sites More sharing options...
Recommended Posts