Table of contents
- Getting Started
- Microsoft Office Spreadsheet Component Accessibility
- Using Spreadsheet Tools
-
Designing Spreadsheets
- Create a Microsoft Office Spreadsheet Component
- Add or remove sheets
- Change the name of a sheet
- Change the order of sheets
- Show or hide column headers or row headers
- Show or hide gridlines in a spreadsheet
- Show or hide the sheet selector
- Show or hide scroll bars
- Show or hide sheets
- Show only part of a spreadsheet
- Change which cell becomes active when you press ENTER
- Keep specific rows or columns visible as you scroll a spreadsheet
- Turn automatic sizing on or off for a spreadsheet
- Create a chart based on a spreadsheet
- Save changes
- Undo changes
- Print a spreadsheet
- Remove protection from a spreadsheet
- Restrict use of a spreadsheet in the browser
- How a spreadsheet handles dates in the year 2000 and beyond
- Entering and Changing Data
-
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
- Programming Information
- Troubleshoot Spreadsheets