documentation
.HELP!
Office Web Components Documentation
Select an array formula range
Office Web Components
previous page
next page
Select an array formula range
Select a cell within the array.
Press CTRL+/ (forward slash).
previous page
start
next page
Menu
Homepage
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
Get in touch
Submit feedback about this site to:
[email protected]