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.
Freezing rows and columns in spreadsheets
When a spreadsheet is very long or wide, you can freeze table headers or other contents and make them visible on the screen all the time by using the Freeze Rows
and Freeze Columns
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 spreadsheets
You can use keyboard shortcut keys in all browsers or menu item only in IE browser to cut, copy, and paste data and images within a spreadsheet, between spreadsheets, or between a spreadsheet and an external application.
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.