| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot Copy/Paste Array Formula
I have an array formula (located in row P8519) that I would like to
copy/paste down Column P but I constantly get the error message "You cannot change part of an array". What do I need to do in order to copy/paste such formula? Thanks. -- tb |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot Copy/Paste Array Formula
When you select any cell within the multi-cell array, press Ctrl + "/"
(backslash). This will select the entire array range involved. Then right-click Copy. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "tb" wrote in message ... I have an array formula (located in row P8519) that I would like to copy/paste down Column P but I constantly get the error message "You cannot change part of an array". What do I need to do in order to copy/paste such formula? Thanks. -- tb |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot Copy/Paste Array Formula
On Dec 12, 9:42 am, "Max" wrote:
When you select any cell within the multi-cell array, press Ctrl + "/" (backslash). This will select the entire array range involved. Then right-click Copy. -- Max Singaporehttp://savefile.com/projects/236895 xdemechanik ---"tb" wrote in message ... I have an array formula (located in row P8519) that I would like to copy/paste down Column P but I constantly get the error message "You cannot change part of an array". What do I need to do in order to copy/paste such formula? Thanks. -- tb Thanks, Max! -- tb |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot Copy/Paste Array Formula
welcome
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "tb" wrote Thanks, Max! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy an array formula? | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| copy array formula | Excel Worksheet Functions | |||
| Copy An Array Formula | Excel Discussion (Misc queries) | |||
| Effective method to paste array formula | Excel Worksheet Functions | |||
Linear Mode
