• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
:
Communities
  • Contact Support
      • Sign in
    • Content
    • People
    • Search
    • Support Communities
    • iWork
    • Numbers for Mac
      • All Content (26410)
      • User Tips (9)
      • Discussions (26401)
      • Thumbnails
      • Details
      • Hierarchy
      Filter by tag
      Previous1…34567Next
      • Thread Numbers spreadsheet won't open on my Mac Air

        Numbers spreadsheet won't open on my Mac Air

        I created a Numbers spreadsheet on my Macbook Pro very recently and mailed it to my friends Macbook Air. She can't open it. Message comes up saying can't open this file. Both computers are less than 4 years old. Only ...view more
        Wayne Contello
        last modified by Wayne Contello
        • 0
        • 1
        Numbers spreadsheet won't open on my Mac Air

        in Numbers for Mac

          Back
        • Thread Using Applescript for formatting rows in Numbers

          Using Applescript for formatting rows in Numbers

          I have a Numbers spreadsheet where I would like to shade the rows depending on the values (even/odd) in my second (B) column.   I've been all over the forum, but I can't seem to find a script that matches, and I...view more
          jsteinaa
          last modified by jsteinaa
          • 0
          • 4
          Using Applescript for formatting rows in Numbers

          in Numbers for Mac

            Back
          • Thread Use of number formula

            Use of number formula

            Numbers 3.6.2 Header 1 Header 2 Header 3 Header 4 Header 5 7:00 x z y   I need to solve a problem. The header 1 is a duration. If in header 2 or 3 is present x the value in header 1 will be copied in header 4....view more
            onopilot
            last modified by onopilot
            • 0
            • 8
            Use of number formula

            in Numbers for Mac

              Back
            • Thread Automatic calculation at the end of every month

              Automatic calculation at the end of every month

              Numbers 3.6.2  I need to have the value of one cell added to the value of another cell at either the end or the beginning of every month. It seems like it should be fairly simple to do but I can't seem to figure ...view more
              Barry
              last modified by Barry
              • 0
              • 7
              Automatic calculation at the end of every month

              in Numbers for Mac

                Back
              • Thread Numbers has a bizarre problem

                Numbers has a bizarre problem

                problem with numbers spread sheet   When I select a cell then type my required formula of - 1/(cell a/cell b) this happens:   After I type 1 and then type the divide symbol it simply types the + again and ag...view more
                Barry
                last modified by Barry
                • 0
                • 5
                Numbers has a bizarre problem

                in Numbers for Mac

                  Back
                • Thread Index.MXL file missing

                  Index.MXL file missing

                  Numbers spreadshetsposting aneroid message "Index.MXL file is missing" I can't open these spreadsheets.view more
                  Barry
                  last modified by Barry
                  • 0
                  • 3
                  Index.MXL file missing

                  in Numbers for Mac

                    Back
                  • Thread How do I edit an existing Numbers document?  Selecting the cell does not activate it.

                    How do I edit an existing Numbers document?  Selecting the cell does not activate it.

                    How do I edit an existing Numbers document when selecting a cell does not activate it or allow me to make changes.view more
                    Wayne Contello
                    last modified by Wayne Contello
                    • 0
                    • 1
                    How do I edit an existing Numbers document?  Selecting the cell does not activate it.

                    in Numbers for Mac

                      Back
                    • Thread how do I link data from one numbers sheet with another sheet

                      how do I link data from one numbers sheet with another sheet

                      I have 3 different sheets covering my sales and finances. how can I link certain data in one sheet with the other 2 sheets?view more
                      t quinn
                      last modified by t quinn
                      • 0
                      • 3
                      how do I link data from one numbers sheet with another sheet

                      in Numbers for Mac

                        Back
                      • Thread how to calculate across sheets

                        how to calculate across sheets

                        Hi. I have a Numbers document with multiple sheets. How can I calculate the subtotals from each sheet in one cell on the last sheet?   Thanksview more
                        ScooterG
                        last modified by ScooterG
                        • 0
                        • 2
                        how to calculate across sheets

                        in Numbers for Mac

                          Back
                        • Thread 'Questions students missed the most' graph

                          'Questions students missed the most' graph

                          I'm a math teacher, and want to get a graph and some stats about which questions were missed, and have a nice visual graph of that and get some statistics from there. I'm having trouble getting this done, not sure if ...view more
                          Wayne Contello
                          last modified by Wayne Contello
                          • 0
                          • 1
                          'Questions students missed the most' graph

                          in Numbers for Mac

                            Back
                          • Thread volume size to support permanent storage of Numbers File

                            volume size to support permanent storage of Numbers File

                            I have a Numbers file that I store in an encrypted disk image.  Every time I exit, after making a change to the file I get the following message - "The document “Words handheld.numbers” is on a volume...view more
                            Fly1Boy
                            created by Fly1Boy
                            • 0
                            • 0
                            volume size to support permanent storage of Numbers File

                            in Numbers for Mac

                              Back
                            • Thread numbers text to rtf or pages (without formatting)

                              numbers text to rtf or pages (without formatting)

                              i have a very comprehensive list of items in two columns that i would like to move to a pages or rtf document.   i have removed the cell colors and the outlines and seem to have been able to paste it into a rtf ...view more
                              pamfrombalwyn
                              last modified by pamfrombalwyn
                              • 0
                              • 3
                              numbers text to rtf or pages (without formatting)

                              in Numbers for Mac

                                Back
                              • Thread Auto-Populate Agenda

                                Auto-Populate Agenda

                                Hi, I'm trying to automatically populate a "Daily Agenda" from a "Task Chart" as in the picture below.  When the date of the daily agenda is changed I'd like the tasks and details from my task chart to automatic...view more
                                David Ostler
                                last modified by David Ostler
                                • 1
                                • 2
                                Auto-Populate Agenda

                                in Numbers for Mac

                                  Back
                                • Thread how to print selected cells in numbers

                                  how to print selected cells in numbers

                                  Does anyone know how to print selected cells in a Numbers spreadsheet, rather than printing the entire sheet?   Also, how to save the selected cells as a pdf file without saving the irrelevant cells?view more
                                  Yellowbox
                                  last modified by Yellowbox
                                  • 0
                                  • 31
                                  how to print selected cells in numbers

                                  in Numbers for Mac

                                    Back
                                  • Thread Transpose column from one table to row headers in another and populate with data from original  table

                                    Transpose column from one table to row headers in another and populate with data from original  table

                                    Hi,   Similar to one of my previous posts, I am trying to extract data from a column based on a "text" value when a match is found in another. The the example shown below, I am attempting to populate Table 2 wit...view more
                                    PASEL
                                    created by PASEL
                                    • 0
                                    • 0
                                    Transpose column from one table to row headers in another and populate with data from original  table

                                    in Numbers for Mac

                                      Back
                                    • Thread IF funktion

                                      IF funktion

                                      Hi, I have a checklist and if B3 is checked the value of F3 is displayed in G3 and G should accumulate (see screehshot) (IF B3=TRUE;F3) works with row 3 to accumulate I used the formular (IF B4=TRUE;F4+G3) but...view more
                                      Frisi
                                      last modified by Frisi
                                      • 0
                                      • 4
                                      IF funktion

                                      in Numbers for Mac

                                        Back
                                      • Thread This may be tricky...

                                        This may be tricky...

                                        So I have a couple amortization tables (not shown) that I'm working on with one for 5 and one for 10 years. In this graph  (that works off the amortization tables) I'm working with results from each table. It's c...view more
                                        Brian Entz
                                        last modified by Brian Entz
                                        • 0
                                        • 2
                                        This may be tricky...

                                        in Numbers for Mac

                                          Back
                                        • Thread メニューバーが英語のままで日本語に変更出来ない

                                          メニューバーが英語のままで日本語に変更出来ない

                                          メニューバーが英語のままで日本語に変更出来ないview more
                                          さとしくん
                                          last modified by さとしくん
                                          • 0
                                          • 1
                                          メニューバーが英語のままで日本語に変更出来ない

                                          in Numbers for Mac

                                            Back
                                          • Thread Excel 2011 Corrupt Files from .xlsm

                                            Excel 2011 Corrupt Files from .xlsm

                                            I've been dealing with this issue for several months. I receive an .xlsm file from a remote coworker, who is Windows based. Opens perfectly the first time after receiving. Then I work on the file, save and close. Go t...view more
                                            itscraigdude
                                            last modified by itscraigdude
                                            • 0
                                            • 2
                                            Excel 2011 Corrupt Files from .xlsm

                                            in Numbers for Mac

                                              Back
                                            • Thread Calculate the mean per time slot ?

                                              Calculate the mean per time slot ?

                                              Hi Chaps,   I'm an absolute beginner on Numbers (almost everything on Mac i would say) and i need help to calculate mean values. Those are calculated values (Column 2) taken on a precise moment of the day (Colu...view more
                                              dragandpaste
                                              last modified by dragandpaste
                                              • 0
                                              • 2
                                              Calculate the mean per time slot ?

                                              in Numbers for Mac

                                                Back
                                              Previous1…34567Next

                                              This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. 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.

                                              • Support
                                              • Apple Support Communities

                                              Shop the Apple Online Store (1-800-MY-APPLE), visit an Apple Retail Store, or find a reseller.

                                              • Apple Info
                                              • Site Map
                                              • Hot News
                                              • RSS Feeds
                                              • Contact Us
                                              • Choose your country or region

                                              Copyright © Apple Inc. All rights reserved.

                                              • Terms of Use
                                              • Updated Privacy Policy
                                              • Cookie Usage