A range can be a single cell, a rectangular block of adjoining cells, an entire sheet, or an entire spreadsheet. A range is represented as the addresses of its beginning and ending cells, separated by two periods. For example, A1:B4.
You can sort the data in a column or in a range, in ascending or descending order, based on the values in a column you specify. For English, the sort order is alphabetical. The sort order for German, Japanese, and French is controlled by the locale convention; for other languages, the order is controlled by Unicode values only.
Using instant filters
Instant filters insert a combination box control on a data column so that you can select the records (rows) to be displayed.
Hiding rows and columns
You can hide rows and columns in a spreadsheet.
Showing rows and columns
You can show hidden rows and columns in a spreadsheet.
Referencing cells from another sheet
To avoid maintaining the same data on more than one sheet, you can link cell values on different sheets by using a reference.
Copying data and images
To copy and paste data or images within a spreadsheet, between spreadsheets or between spreadsheet and external applications.
Naming a range
Make formulas easier to write and understand by naming important cell ranges and using the names in place of range addresses in formulas.
Finding or editing named ranges
Use the Manage Named Ranges window to find all named ranges in a spreadsheet, or adjust which cells are included in a specific range.
Removing a named range
Use the Manage Ranges window to remove a named range without deleting the data that the range contains.
Relative and absolute references
In formulas, you can represent data by using the cell address where the data is stored.