documentation.HELP! Office Web Components Documentation

Microsoft Office 2003 Spreadsheet Component Help

Office Web Components

Table of contents

• Getting Started
  • About spreadsheets
  • About XML lists
  • Browser support for spreadsheets
  • About using a spreadsheet in the browser
  • About Microsoft Office Web Components
  • About installing, licensing, and distributing Office Web Components
  • About View-only mode for Office Web Components
  • Create a Microsoft Office Spreadsheet Component
  • About accessing a data source on a different domain
  • Getting Help
    • About getting help for spreadsheets
• Microsoft Office Spreadsheet Component Accessibility
  • Keyboard shortcuts in spreadsheets
• Using Spreadsheet Tools
  • About spreadsheet tools, commands, and options
  • Show or hide the spreadsheet toolbar
  • Show or hide the Commands and Options dialog box
• Working with Spreadsheets
  • 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
  • Save changes
  • Undo changes
  • Print a spreadsheet
  • Show or hide sheets
  • Show or hide scroll bars
  • Show only part of a spreadsheet
  • Turn automatic sizing on or off for a spreadsheet
• 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
  • Keep specific rows or columns visible as you scroll a spreadsheet
  • Change which cell becomes active when you press ENTER
• 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
• Working with Array Formulas
  • About array formulas and array constants
  • Create an array formula
  • Edit an array formula
  • Select an array formula range
  • Move or copy an array formula
• Working with Functions
  • About using spreadsheet functions
• Formatting Spreadsheets and Data
  • Format cells in a spreadsheet
  • Number formats
  • Merge or unmerge cells
  • Change the width of a column
  • Change the height of a row
  • Display text or a spreadsheet so that it reads right to left or left to right
  • Create a chart based on a spreadsheet
• Finding, Sorting, and Filtering Data
  • About finding data
  • Find data
  • Sort data
  • Apply or remove a filter
  • Sum filtered data
• Importing and Exporting Data
  • About spreadsheets published from Excel
  • Export a spreadsheet to an Excel workbook
  • Get data from other sources
  • Restrict use of a spreadsheet in the browser
  • Remove protection from a spreadsheet
  • About making connections to external data sources more secure
• Programming Information
  • Troubleshooting Spreadsheets
    • Troubleshoot spreadsheets
    • Troubleshoot error values in a spreadsheet

next page

Get in touch

Submit feedback about this site to:

• [email protected]