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.
