documentation
.HELP!
Microsoft Office Web Components Documentation
Move or copy an array formula
Microsoft Office Web Components
previous page
next page
Show All
Move or copy an array formula
Select the entire array range.
How?
Select a cell within the array.
Press CTRL+/ (forward slash).
Click
Cut
or
Copy
on the spreadsheet
toolbar
.
Select the entire destination range; otherwise, the array will be pasted into a single cell.
Click
Paste
.
previous page
start
next page
Menu
Homepage
Table of contents
Getting Started
About spreadsheets
About XML lists
Browser support for spreadsheets
About Microsoft Office Web Components
About View-only mode for Office Web Components
About accessing a data source on a different domain
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
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
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
Troubleshooting Spreadsheets
Troubleshoot error values in a spreadsheet
Troubleshoot spreadsheets
Get in touch
Submit feedback about this site to:
[email protected]
How?
or Copy
on the spreadsheet toolbar.
.