| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how copy formula and only paste into 20,000 cells
i have a formula and want to copy it into only 20,000 cells instead of the
entire 65,000 is there a way to select a range |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how copy formula and only paste into 20,000 cells
With formula in A1 type A1:A20000 in name box then hit ENTER.
Then hit CTRL + d Gord Dibben MS Excel MVP On Wed, 28 Feb 2007 13:01:00 -0800, dlb1228 wrote: i have a formula and want to copy it into only 20,000 cells instead of the entire 65,000 is there a way to select a range |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
| copy and paste between cells that have data | Excel Worksheet Functions | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| How to copy and paste same formula in multiple cells? | Excel Worksheet Functions | |||
Linear Mode
