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. In Release 1, 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 Filter
The Instant Filter function inserts a combo box on a data column that lets you 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 in and between spreadsheets
Use the Web Clipboard icon to copy and paste spreadsheet data and images.
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 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.