answersLogoWhite

0


Best Answer
Select data in a column to be sorted (including title row). Go to sort and filter (this will be in different places depending on version of excel), then custom sort, then select A-Z.

Any other time you can use this to reverse from low to high (Z-A) or low to high (A-Z). It may also appear under sort -descending or ascending. This does the same thing.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you sort column in an Excel document from 1 to 1000 if the numbers are currently 1000 to 1?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the address of 255 column in Excel?

Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.


How can you add percentage to all numbers in same column on excel?

Get an accountant


How do you add the total or a column full of numbers without using a calculator?

Since you put this question in the Excel category, I will answer relative to what you can do with Excel. The quick way is to highlight the column of numbers and click on the Auto-Sum button.


Is A column identified by the numbers down the left side of the window in excel?

No. A column is identified by the letters at the top of the window.


How do you insert rows in Excel 2007 past IV?

Column IV is not the last column in Excel 2007, as it was in Excel 2003. In Excel 2003 the last column is IV which is column 256. In Excel 2007 the last column is XFD, which is column 16384.


How do I clear a document in Microsoft Excel?

Select the entire document and press the Delete key. You can select the document by pressing Ctrl- A, or by pressing Ctrl and Shift and the spacebar. You can also click on button that is above the row heading for row 1 and to left of the column heading for column A.


How do you keep the header column in Excel visible through out the document?

Use Page Layout view. In Excel 2007, it is located on the View tab of the ribbon, in the Workbook Views section.


How would you filter a list of names or numbers in a column in Microsoft excel Excel?

By means using Filter . From filtered column We should select Custom , In custom we should select begins with where we can give the name or number


How do you total a column on Excel?

The best way to do it is to use the SUM function. Put the cursor in the cell at the below the column numbers and press the Autosum button.


How do you change column A default to a numeric number?

In Excel all columns default numeric characters to numbers.


What is the easiest way to create a sum of all the numbers in a column in Excel?

By using the Autosum feature. Select the cell below the last number and click on the Autosum and it will automatically total the numbers in the column.


What is the last column letter in Excel 2010?

That depends on the version. Up to version 2003, it was row 65,536. From Excel 2007 onwards, it is row 1,048,576.