| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a range
I want to copy a formula to a range that is 1200 cells down
is there a quick copy command to di it |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy a range
aside from highlighting and pasting? Does it match the height of a table? Use
Ctrl+arrow keys to quickly navigate to top/bottom/left/right of table and paste. "Dave" wrote: I want to copy a formula to a range that is 1200 cells down is there a quick copy command to di it |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy a range
Hi
Copy the cell with your formula, then select the cells where you want the formula to copied to, then goto Edit Paste special Check "Formulas" OK¨ Regards, Per "Dave" skrev i meddelelsen ... I want to copy a formula to a range that is 1200 cells down is there a quick copy command to di it |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy a range
Select the cell with the formula............say A1
In NameBox type A1:A1200 and ENTER CTRL + d to copy down. Gord Dibben MS Excel MVP On Thu, 2 Oct 2008 11:55:03 -0700, Dave wrote: I want to copy a formula to a range that is 1200 cells down is there a quick copy command to di it |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
| copy range and paste into every 3rd cell of new range | New Users to Excel | |||
| Copy Range | Excel Discussion (Misc queries) | |||
| How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
| copy a range without the same value | Excel Discussion (Misc queries) | |||
Linear Mode
