You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers not sorting as normal.

In Numbers, I have added 3 rows to my sheet and then tried to sort ascending. The sort responce was the new rows were excluded from the sort request. Why ?

iMac 27″, macOS 11.1

Posted on Feb 1, 2021 4:23 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 2, 2021 1:33 AM

Hi SGill,


Thank you for your prompt reply. Now, having had another look at my sheet, I can see that your supposition that the problem is with the "footers", was correct. I have now cleared this by reducing the value in the text box to 0. Brilliant.

All very easy if you know.

This app has a very steep learning curve for me.

Another oddity, one that does not stop me using the app. , which I don't understand, is something to do with "Quick Filter". If I click on the down arrow above column A and go to Quick Filter, it opens a view as my screen shot.

Sorry I can't paste it into this screen !

Another problem. I can't drag the screen shot into this window, or even paste a photo made on iPhone in ?


The screen shot shows a drop down menu, and the Quick Filter arrow, pointing to a section of the top rows of column A.

At the top, of this section, grayed out, it says. "Show rows containing:"


I have tried to switch off filters, but that will not switch.


This has seemly always been there, but I don't know what it is telling me, or how to close it.


Any thoughts.



3 replies
Question marked as Top-ranking reply

Feb 2, 2021 1:33 AM in response to SGIII

Hi SGill,


Thank you for your prompt reply. Now, having had another look at my sheet, I can see that your supposition that the problem is with the "footers", was correct. I have now cleared this by reducing the value in the text box to 0. Brilliant.

All very easy if you know.

This app has a very steep learning curve for me.

Another oddity, one that does not stop me using the app. , which I don't understand, is something to do with "Quick Filter". If I click on the down arrow above column A and go to Quick Filter, it opens a view as my screen shot.

Sorry I can't paste it into this screen !

Another problem. I can't drag the screen shot into this window, or even paste a photo made on iPhone in ?


The screen shot shows a drop down menu, and the Quick Filter arrow, pointing to a section of the top rows of column A.

At the top, of this section, grayed out, it says. "Show rows containing:"


I have tried to switch off filters, but that will not switch.


This has seemly always been there, but I don't know what it is telling me, or how to close it.


Any thoughts.



Feb 1, 2021 5:18 AM in response to jonphotographer

Sort doesn't sort sheets (which are blank canvases on which you place tables and other objects). Do you mean you are trying to sort a table?


It is hard to say what is going on with your table without seeing a screenshot. Perhaps you added rows at the bottom that are defined as Footer Rows?


Or perhaps you have selected a subset of your rows and then chosen 'Sort Selected Rows' in the sidebar at the right?


For general instructions on how to sort, go to Help > Numbers Help in your menu and search for 'sort'.


SG

Feb 2, 2021 10:43 AM in response to jonphotographer

HI Jon,


For future reference:


To take a screenshot of part of the screen:


• Place the mouse pointer at the top left corner of the area to be captured.


• Press shift-command-4


(The pointer will change to a crosshair)


• Press and hold the mouse button and drag the crosshair to the bottom right corner of the area to be captured.


• When the selection rectangle holds the area you want to capture, release the mouse button.


(You'll hear a 'shutter click,' and the image will be saved as a file on your desktop, with the name Screen Shot, followed by the date and time the shot was taken.)


Your screenshot of a table should be taken while the table or one of the cells in the table is selected, making the table active, and ensuring that the row and column reference tabs are visible. Please include these tabs in any screenshot images.




To insert an image (or other image) in your post:


• Place the insertion bar at the point you want the image inserted.


(I usually press a return after the line of text I want above the image.)


• Click the 'two mountains' button, second from Right in the set below the message composition window.


(This will take you to a Finder window showing the files on your Desktop. If they are sorted by Date, descending from most recent, your screen shot should be at or very near the top of the list.)


• Double-click the Screen Shot's icon.


(The window will close, you;ll be taken back to your message, and after a short pause, the image will appear in your message.)


• Press return to start a new line below the image, and carry on.




Regards


Barry




Numbers not sorting as normal.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.