• 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 (26399)
      • User Tips (9)
      • Discussions (26390)
      • Thumbnails
      • Details
      • Hierarchy
      Filter by tag
      Previous1…34567Next
      • 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
                              • Thread Find percentage of double false pairs within five two column sets

                                Find percentage of double false pairs within five two column sets

                                The situation is that I have four sets of two related columns, and those four sets are repeated over 17 sheets. They are all check boxes (basically and either or), and I've already got it set up to do quite a bit when...view more
                                myCompliments
                                last modified by myCompliments
                                • 0
                                • 3
                                Find percentage of double false pairs within five two column sets

                                in Numbers for Mac

                                  Back
                                • Thread key   /   (divide), doesn’t work

                                  key   /   (divide), doesn’t work

                                  key   /   (divide), doesn’t work in formula (instead print  +  ), what to do?view more
                                  allaart
                                  last modified by allaart
                                  • 0
                                  • 2
                                  key   /   (divide), doesn’t work

                                  in Numbers for Mac

                                    Back
                                  • Thread in the previous version, the menu table in table options, there is an option that gives me the option: the Return key moves to next cell. I do not see this option in the new number. can you help me please?

                                    in the previous version, the menu table in table options, there is an option that gives me the option: the Return key moves to next cell. I do not see this option in the new number. can you help me please?

                                    in the previous version  of Number, the menu table in table options, there is an option that gives me the option: the Return key moves to next cell. I do not see this option in the new number. can you help me ple...view more
                                    AMDavis
                                    last modified by AMDavis
                                    • 0
                                    • 5
                                    in the previous version, the menu table in table options, there is an option that gives me the option: the Return key moves to next cell. I do not see this option in the new number. can you help me please?

                                    in Numbers for Mac

                                      Back
                                    • Thread Pie Chart references not working

                                      Pie Chart references not working

                                      I have a table with a column of averages in column P.  The labels for the averages are in column B.  I click C to insert the chart, then pie chart, then add data.  I click "wedges" to allow me to identi...view more
                                      Wayne Contello
                                      last modified by Wayne Contello
                                      • 0
                                      • 5
                                      Pie Chart references not working

                                      in Numbers for Mac

                                        Back
                                      • Thread Extracting text from strings in a single cell from a row of cells

                                        Extracting text from strings in a single cell from a row of cells

                                        Hi,   Is there an easier way to lookup a text / word in a string within row of cells and where a match is found return a header text - see example shown below. The table on the left contains the original comp...view more
                                        PASEL
                                        last modified by PASEL
                                        • 0
                                        • 8
                                        Extracting text from strings in a single cell from a row of cells

                                        in Numbers for Mac

                                          Back
                                        • Thread linking sheets

                                          linking sheets

                                          I have a very simple spreadsheet/database in Numbers. There are several sheets for various geograpgic regions. There is one sheet at the front that I would like to contain links that take the user to a regional sheet....view more
                                          SGIII
                                          last modified by SGIII
                                          • 1
                                          • 8
                                          linking sheets

                                          in Numbers for Mac

                                            Back
                                          • Thread Numbers Sort Capabilities (Macbook Pro mid 2009; OS10.11.6; Numbers 3.6.2

                                            Numbers Sort Capabilities (Macbook Pro mid 2009; OS10.11.6; Numbers 3.6.2

                                            I have been searching but cannot find an answer to:- If I have added a sort column then how do I delete one or more of the selected rows/columns in the sort - or even just reset my sort options?  I see that I ...view more
                                            Terry Q Brinkworth
                                            last modified by Terry Q Brinkworth
                                            • 0
                                            • 6
                                            Numbers Sort Capabilities (Macbook Pro mid 2009; OS10.11.6; Numbers 3.6.2

                                            in Numbers for Mac

                                              Back
                                            • Thread I need to get 2 decimal places when using a formula for a quotient and Numbers will only give me whole integers which is useless since most items will be less than 1. How can I change this?

                                              I need to get 2 decimal places when using a formula for a quotient and Numbers will only give me whole integers which is useless since most items will be less than 1. How can I change this?

                                              How do I get 2 decimal places when using a formula for a quotient? It only gives me whole integers. Most of the results will be less than 1 so I need 2 decimal placesview more
                                              keekeebird
                                              last modified by keekeebird
                                              • 0
                                              • 3
                                              I need to get 2 decimal places when using a formula for a quotient and Numbers will only give me whole integers which is useless since most items will be less than 1. How can I change this?

                                              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