documentation
.HELP!
Office Components Spreadsheet Documentation
Select an array formula range
Office 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 Microsoft Office Web Components
About View-only mode for Office Web Components
Getting Help
About getting design 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
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
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 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
Export a spreadsheet to an Excel workbook
Troubleshoot Spreadsheets
Troubleshoot spreadsheets
Troubleshoot error values in a spreadsheet
Get in touch
Submit feedback about this site to:
[email protected]