iWork '09 - Number


Recommended Posts

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

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

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).

post-17580-1253721443_thumb.png

Link to comment
Share on other sites

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

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

@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

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

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

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.