documentation
.HELP!
MS OFfice Web Components Spreadsheet Documentation
Select an array formula range
MS OFfice Web Components Spreadsheet
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
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
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
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
About entering text, numbers, dates, and times in a spreadsheet
Enter text, numbers, dates, and times in a spreadsheet
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
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
Function Reference
owcfun10.chm::\owcfun10.hhc
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
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
Get data from other sources
Export a spreadsheet to an Excel workbook
Programming Information
Troubleshoot Spreadsheets
Troubleshoot spreadsheets
Troubleshoot error values in a spreadsheet
Get in touch
Submit feedback about this site to:
[email protected]