Table of contents
- Getting Started
- Microsoft Office Spreadsheet Component Accessibility
- Using Spreadsheet Tools
- Working with Spreadsheets
-
Entering and Changing Data
- About entering text, numbers, dates, and times in a spreadsheet
- Enter text, numbers, dates, and times in a spreadsheet
- How a spreadsheet handles dates in the year 2000 and beyond
- Change data in a cell
- About moving and copying data
- Move and copy data
- Insert or delete rows or columns
- Insert, change, or delete a hyperlink
- Clear cell contents
-
Working with Formulas
- About formulas
- Examples of commonly used formulas
- Create a formula
- Change a formula
- View a formula and its result at the same time
- Insert a total for a range
- Change when a spreadsheet calculates
- About using names in formulas
- Define names for cells, formulas, or constants
- Change or delete a defined name
- About cell and range references
- About calculation
- About calculation operators
- About creating a formula that uses data on the same Web page
- Working with Array Formulas
- Working with Functions
- Formatting Spreadsheets and Data
- Finding, Sorting, and Filtering Data
- Importing and Exporting Data
- Troubleshoot Spreadsheets