Sorting Data in Google Sheets

How to sort data in Google Docs Spreadsheet?

Explanation

In Google docs spreadsheet, data can be sorted in two different formats,
1. Sort Sheet
2. Sort range
Sort Sheet:
Using this format, data in the sheet can be sorted based on a single column.
Step 1: Select the range of cells to be sorted.
Step 2: Click Data and select "Sort sheet by column" as shown below,
sorting google spreadsheet
Step 3: Data sorted alphabetically from A to Z,
sorting google spreadsheet1
Sort Range:
Data can be sorted only within the selected range instead of whole worksheet.
Step 1: Select the range .
Step 2: Click Data and choose "Sort range by".
sorting range google spreadsheet
Step 3: Data in the column B alone sorted alphabetically.
sorting range google spreadsheet1


Related Topics

Google Docs Spreadsheet Tutorial