• 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 (26374)
      • User Tips (9)
      • Discussions (26365)
      • Thumbnails
      • Details
      • Hierarchy
      Filter by tag
      Previous123456Next
      • 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
                    • Thread Numbers - Remove Hyperlinks

                      Numbers - Remove Hyperlinks

                      Hi - I'm using the lastest version of Numbers on Maverick and I'm editing documents with links in them.  However, every time I make a change in a cell, the link turns to a hyperlink.  I know how to remove ea...view more
                      anklebyter
                      last modified by anklebyter
                      • 0
                      • 8
                      Numbers - Remove Hyperlinks

                      in Numbers for Mac

                        Back
                      • Thread Numbers: Drop-down menu choice

                        Numbers: Drop-down menu choice

                        For numbers. I'm creating a database and in one of the column there's going to be a dropdown menu made with a few choices to pick from.  When picking one of the choices, I'd like for that line to be copied and a...view more
                        t quinn
                        last modified by t quinn
                        • 0
                        • 5
                        Numbers: Drop-down menu choice

                        in Numbers for Mac

                          Back
                        • Thread Transfer a running total to a new cell.  A computed running total in one column transfered to a cell in the next column

                          Transfer a running total to a new cell.  A computed running total in one column transfered to a cell in the next column

                          In my numbers spread sheet I have a column that calculates totals for two columns and then as a running total.  I need to move the running total computation to a cell in the next column.  I'm not sure how to...view more
                          kpcbloom
                          last modified by kpcbloom
                          • 1
                          • 3
                          Transfer a running total to a new cell.  A computed running total in one column transfered to a cell in the next column

                          in Numbers for Mac

                            Back
                          • Thread Working with the IF command and checklists

                            Working with the IF command and checklists

                            Hello,   I have a question that I'm struggling with regarding the If command.   Basically, I am setting up a spreadsheet for my taxes, and I have certain recurring expenses that I can only put a certain p...view more
                            Wayne Contello
                            last modified by Wayne Contello
                            • 0
                            • 1
                            Working with the IF command and checklists

                            in Numbers for Mac

                              Back
                            • Thread numbers

                              numbers

                              I just updated my iOS devices to iOS10 yesterday and while I can access my Numbers/Pages documents on all those devices, now it's telling me I can't open them on my Macbook Air.   I have changed nothing on my Ma...view more
                              smp.mac
                              last modified by smp.mac
                              • 0
                              • 4
                              numbers

                              in Numbers for Mac

                                Back
                              • Thread Creating Shortcuts

                                Creating Shortcuts

                                A period / decimal point on Apple's French keyboard requires holding down the CAP key.  This is a pain when inputting numbers into Numbers. The numeric keypad attached to the keyboard has a comma instead of a per...view more
                                Chris Haine
                                created by Chris Haine
                                • 0
                                • 0
                                Creating Shortcuts

                                in Numbers for Mac

                                  Back
                                • Thread Deleting Duplicate Rows in a list

                                  Deleting Duplicate Rows in a list

                                  Hey folks, I've scowered around a bit for the answer to this and can't for the life of my figure it out. I've got a list of ~2,000-3,000 words in the following format: Fact Fiction Funny Funny Funny Funky etc etc....view more
                                  ※※
                                  last modified by ※※
                                  • 0
                                  • 5
                                  Deleting Duplicate Rows in a list

                                  in Numbers for Mac

                                    Back
                                  • Thread AppleScript for Numbers

                                    AppleScript for Numbers

                                    Hello,   I've got an AppleScript which helps me generate a price list. Everything is working just fine but since an update it behaves a little different.   When I started using the script it was very fast ...view more
                                    SGIII
                                    last modified by SGIII
                                    • 0
                                    • 5
                                    AppleScript for Numbers

                                    in Numbers for Mac

                                      Back
                                    • Thread if then formula with cell format

                                      if then formula with cell format

                                      Hey, im doing some contract work with my business and working formula to get understanding on finacial positions. as you can see I have set up a income at the top, expenses through the middle and then surplus and de...view more
                                      Wayne Contello
                                      last modified by Wayne Contello
                                      • 0
                                      • 1
                                      if then formula with cell format

                                      in Numbers for Mac

                                        Back
                                      • Thread is there a sort of "tally" method or formula so you don't need to add the new numbers you input yourself?

                                        is there a sort of "tally" method or formula so you don't need to add the new numbers you input yourself?

                                        I'm making a numbers spreadsheet for my mother-in-laws retail business. I have everything set up fine, but she wanted to know if there was a sort of "tally" way to add the new numbers she has to input every day, inste...view more
                                        Wayne Contello
                                        last modified by Wayne Contello
                                        • 0
                                        • 3
                                        is there a sort of "tally" method or formula so you don't need to add the new numbers you input yourself?

                                        in Numbers for Mac

                                          Back
                                        • Thread how to build a dashboard in numbers

                                          how to build a dashboard in numbers

                                          How would you build a dashboard in numbers?view more
                                          Pacificarrgghh
                                          last modified by Pacificarrgghh
                                          • 0
                                          • 3
                                          how to build a dashboard in numbers

                                          in Numbers for Mac

                                            Back
                                          • Thread Compare two columns and get percentage of cells that match

                                            Compare two columns and get percentage of cells that match

                                            Hello, I'm looking to take two columns of data from different tables within the same document, which should have a pretty high percentage of matching checkboxes, and have another cell tabulate the percentage that mat...view more
                                            myCompliments
                                            last modified by myCompliments
                                            • 0
                                            • 3
                                            Compare two columns and get percentage of cells that match

                                            in Numbers for Mac

                                              Back
                                            • Thread Are there any more templates?

                                              Are there any more templates?

                                              As always, Apple has outdone themseleves with this product.  It's perfect for the Soccer Moms but it lacks the full body that excel has.  The real question is:   Are there anymore templetes out there?view more
                                              Peggy
                                              last modified by Peggy
                                              • 0
                                              • 5
                                              Are there any more templates?

                                              in Numbers for Mac

                                                Back
                                              Previous123456Next

                                              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