0
You can sort your data by clicking on "sort and filter" you will see this option at the top bar. This will give you option to sort your selected data acceding or descending order, or you can temporarily filter out your values.
Wiki User
∙ 13y ago
Wiki User
∙ 14y agoSelect the data that you want to sort. Then go to the Data menu and pick the Sort option. You can then choose which column values on which you want to base the sort.
Wiki User
∙ 12y agoJust Select that data to be sorted.
Right click on the data and select sort option.
Just sort that data as required....since you will get options over there to sort the data.
Add your answer:
Earn +20 pts
What data can MS-Excel sort?
It can sort all standard data that can be entered into a spreadsheet. So it can sort numbers, dates, text and logical data (True/False).
How are data organised in spreadsheet?
You can organize data horizontally or vertically. You can use the data to create a chart to display the data. You can alphabetize the data list or sort in a variety of ways.
What Is a common spreadsheet task that allows you to reorder data?
Sorting, which can be done through the Data menu, by picking the Sort option.
What function a spreadsheet have to help organize data?
Spreadsheets have many functions to help organise data. Organising data is one of the purposes of a spreadsheet, particulary if it is a lot of numerical data. If it is things like names, address etc., a database can be better. Spreadsheets can do things like sort data and extract data. They can lay data out in a tabular format using the rows and columns in the spreadsheet. There are some specific database functions that can be used in a spreadsheet that are used for organising data.
What allows users to easily sort data in a spreadsheet?
Spreadsheets allow you to layout data in columns. Once you have your data entered, you can select it and sort it using the built-in sorting facility that all spreadsheet applications have. It is an important aspect of spreadsheets, so all of them have ways of doing everything from simple to much more complex sorting or your data.
Can a spreadsheet collect data?
You can collect data and store it in a spreadsheet.
How do you use the spreadsheet?
To use a spreadsheet, you can input data into cells, create formulas to perform calculations, format cells for specific data types, and create charts for visualization. You can also use functions like sum, average, and VLOOKUP to manipulate data. Additionally, you can apply filters, sort data, and protect your spreadsheet to ensure data integrity.
When data in a spreadsheet programs changed what occurs?
If the spreadsheet contains formulas that rely on the data in the spreadsheet, then changing the data changes the cells on the spreadsheet that utilize the formulas.
When data in a spreadsheet program is changed what occurs?
If the spreadsheet contains formulas that rely on the data in the spreadsheet, then changing the data changes the cells on the spreadsheet that utilize the formulas.
How do you alphabetize lists in Word 2003?
Highlight the list and click on the sort button.
What part of a spreadsheet shows data in a pictorial form?
A spreadsheet does not show a pictorial form, but you can use the data in a spreadsheet to generate a chart, which will show a picture representing the data.
How do you make a list in alphabetical order on neo office?
If you want to sort a spreadsheet, choose the column/line or just a part of it, then pick Data, choose Sort and pick either ascending or descending.
