thanks, that's useful stuff. of course, you could always make up a large table with dummy data for personal testing purposes instead of waiting for the table to grow large over time.
BTW: I just bought numbers and after checking out the help system and tinkering around with a couple of template files, (editing formulas etc), Numbers looks pretty good. I'm going to try and move some of my excel spreadsheet files over to the Mac system and see how it goes. . On Mar 21, 2014, at 10:41 AM, Eugenia Firth <[email protected]> wrote: > Hi there > I realize that I said I hated the program you like, but I think I can answer > some of your questions although Nic brought up something I had not > considered. First, and you may know this already, Numbers will except Excel > files that have got Excel formulas, and you can type in Excel formulas into > Numbers. You can also save out Excel files, including the newest type of > Excel files. > > Let me give you an example of some of the commands for navigation. Command > down arrow will take you to the bottom of the column, and command up arrow > will take you all the way to the top. Command left and right arrows go to the > end of rows. You can add the shift key to these commands to select. If you > press the option key with the left arrow right arrow down arrow or up arrow, > you can add columns and rows. I will tell you that there is one change which > I wish Apple had not made in the new Numbers. It used to be that you could > get to the inspector to change your cell formats, but now it is done > differently. > > It is easy to edit cell formulas, which was not easy in the old Numbers at > all. The older version of Numbers had a lot of memory problems, and I can see > with spreadsheet as big as yours, you would've had a lot of problems using > it. I will say that I haven't yet gotten a sheet with 100 rows yet so I can't > yet speak to that. I will by the end of the year get one that big and will > find out for myself on that. > > Regards, > Gigi > > On Mar 21, 2014, at 8:56 AM, Phil Halton <[email protected]> wrote: > >> Honestly? >> If that's so, and you were a fan of excel, then maybe I'll give it a try. >> Is there a good help system for numbers where I can read up on it and get >> answers? >> I guess I like excel because I've used it for years with JAWS which is >> highly tuned to work with excel. >> How is it working with formulas in numbers? are they easy to set up and edit? >> is basic navigation around a spreadsheet as easy as it is with excel? (arrow >> keys with modifiers like control and shift home and end get you anywhere you >> want to go) >> My largest sheets have at most two tables, or chunks of continuous data, >> and range about 100 rows/6 columns, is that what we're calling "huge"? >> >> On Mar 21, 2014, at 1:35 AM, Nicholas Parsons >> <[email protected]> wrote: >> >>> I used to love Excell, used it all the time, and it was one of the main >>> things I would use Windows for even after getting a Mac. But that has >>> changed with the latest Numbers. I love the latest Numbers more than Excell. >>> >>> Now, to kind of bring this conversation back on topic: One of the things >>> that makes Numbers easier for me, and means I can usually avoid having to >>> jump to a specific cell, is the use of multiple tables on one sheet. >>> Because I usually design my sheets to have multiple tables, navigation is >>> much easier. However, I understand some people will have the need for >>> gigantic tables with huge amounts of data, and in those cases it would be >>> good to have such a short cut key to jump to a specific cell. >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "MacVisionaries" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/group/macvisionaries. >>> For more options, visit https://groups.google.com/d/optout. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/macvisionaries. >> For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
