Skip navigation

Does Numbers do the following?

2170 Views 13 Replies Latest reply: Aug 19, 2012 9:00 PM by Roger D1968 RSS
John Doe1 Level 1 Level 1 (65 points)
Currently Being Moderated
Jul 24, 2012 8:30 AM

In deciding which Office products to buy for my Ipad, I would like to ask if the Apple spreadsheet app "Numbers" has the following features, that have long been in Excel.

 

1. Freeze panes

 

2. Hide and unhide columns

 

3. autofit row height.

 

Please let me know if all three column and row formatting features mentioned above are possible with Apple "Numbers". (If not, you should add those features ASAP.)

 

Thank you.

  • Jerrold Green1 Level 7 Level 7 (28,195 points)
    Currently Being Moderated
    Jul 24, 2012 9:49 AM (in response to John Doe1)

    John,

     

    No. Yes. Yes.

     

    Don't bother telling us, the participants in this forum, what to do ASAP regarding any app. We're just users like you.

     

    Jerry

  • Tom Gewecke Level 9 Level 9 (70,855 points)
    Currently Being Moderated
    Aug 3, 2012 2:57 AM (in response to John Doe1)

    To tell Apple what you want to see go to:

     

    http://www.apple.com/feedback/numbers_ios.html

     

    These forums are really only user-to-user and there is very little chance that anyone relevant from Apple would ever see your suggestions among the millions of questions and answers here.

  • Tom Gewecke Level 9 Level 9 (70,855 points)
    Currently Being Moderated
    Aug 3, 2012 2:12 PM (in response to John Doe1)

    John Doe1 wrote:

     

    Is that still the current version, 2009? No updates since then? The manual also does not say whether it is for the Mac version or Ipad?

     

     

    The manual is for the OS X version.  It has had only minor updates since 2009.

  • Tom Gewecke Level 9 Level 9 (70,855 points)
    Currently Being Moderated
    Aug 3, 2012 4:36 PM (in response to John Doe1)
  • Tom Gewecke Level 9 Level 9 (70,855 points)
    Currently Being Moderated
    Aug 4, 2012 11:28 AM (in response to John Doe1)

    John Doe1 wrote:

     

    it would be nice to have a comprehensive manual for the app. It doesn't come with one?

     

     

    I'm not aware of any Apple manuals for iOS other than what appears in the User Guides for the various devices themselves.   Even for OS X recent apps like iBooks Author have no "manual" beyond the Help.  Of course 3rd parties have produced them for this app, and I suspect you can find some for iOS Numbers too via Google or the iBookstore.

  • Jerrold Green1 Level 7 Level 7 (28,195 points)
    Currently Being Moderated
    Aug 5, 2012 6:54 AM (in response to John Doe1)

    Hi John,

     

    In your original question you asked about "Freeze Panes". That has a definite meaning to Excel users that is not the same thing as Freeze Rows in Numbers, and I didn't want to mislead you by saying that Freeze Panes is available in Numbers. Yes, you might get by with Freeze Rows, and I hope it works for you.

     

    Regarding Unhiding and Hiding, clearly it would be bad if you couldn't unhide and view all data. The ability to hide rows or columns isn't so necessary, and if it isn't supported it wouldn't be tragic, just not convenient.

     

    I'll bet one of the true iOS iWork users will jump in here and comment on wrapping in iOS Numbers.

     

    I don't know how badly you need this information, but if I had these questions, it would be worth $10 to buy the app and find out directly.

     

    Jerry

  • Roger D1968 Calculating status...
    Currently Being Moderated
    Aug 19, 2012 9:00 PM (in response to John Doe1)

    Hi John

     

    Freeze rows and columns is supported in Numbers.  Word wrap is referred to "wrap text in cell". Hide columns and rows is supported in an Excel document but once you unhide it you cannot re-hide it. If you are using this hidden info for formulas in cells, what I have been doing is placing this info on a separate sheet and then discarding it after I print it out.

     

    In my opinion Numbers is the only app out there that I have found that comes close to having the features and functions of Excel but they are not all compatible with each other.

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.