pacman
Lv 5
pacman asked in Computers & InternetSoftware · 8 months ago

how to arrange numbers numerically on excel?

9 Answers

Relevance
  • Anonymous
    8 months ago

    You have lines that go horizontally and column that go vertically to give you a CELL(or box) Each box must have a single number in it. 

    . That is the data

    The column is A

    The outside column is the numbers that are permanent for Excel(you can't change that order or count.

    You can only change the order of your data.

    You put in a number and hit Enter ...put in a number and hit Enter...etc until you are done.

    Now take the mouse arrow up to the A and click on it and it changes color. 

    Now take mouse arrow to data and click on it.

    Click on sort

    Click OK

    It will sort numerically or alphabetically.

    When you want to close the Excel window it asks if you want to save the changes

    Yes.

    • Commenter avatarLogin to reply the answers
  • 8 months ago

    To sort in numerical order:

    Select a cell in the column you want to sort by. From the Data tab, click the ascending command to Sort Smallest to Largest or the descending command to Sort Largest to Smallest. The data in the spreadsheet will be organized numerically.

    • Commenter avatarLogin to reply the answers
  • Dick
    Lv 7
    8 months ago

    Use the sort function on the column or row and select the lowest to highest option.

    • Commenter avatarLogin to reply the answers
  • 8 months ago

    highlight row or column of numbers. right click. sort A - Z

    • Commenter avatarLogin to reply the answers
  • How do you think about the answers? You can sign in to vote the answer.
  • 8 months ago

    This all depends on what exactly you mean thanks Ian for more help see my you tube live stream and leave a comment for more help thanks Ian .

    • Commenter avatarLogin to reply the answers
  • Greg
    Lv 7
    8 months ago

    Use the sort button.

    • Commenter avatarLogin to reply the answers
  • Anonymous
    8 months ago

    Click on the help button or I dont know, unfortunately

    • Commenter avatarLogin to reply the answers
  • 8 months ago

    Highlight the range of numbers then hit click "sort ascending" or "sort descending."

    • Commenter avatarLogin to reply the answers
  • 8 months ago

    Highlight all your data, every column.  Then use the SORT function to put them in order, ascending or descending.

    • Commenter avatarLogin to reply the answers
Still have questions? Get your answers by asking now.