| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
select and paste
I want to copy past a formula in an adjacent cell
and drag it down for all records in the adjacent cell. There are thousands of records Is there a way of selecting and pasting only the cells that has data in it.. rather than selecting the whole column and pasting it? |
|
#2
|
|||
|
|||
|
select and paste
Yes, to select your column and then pull-down:
Edit Goto... Special and then check what you want - constants, formulae, etc. This will end up selecting only certain cells. The do the paste. -- Gary's Student "flow23" wrote: I want to copy past a formula in an adjacent cell and drag it down for all records in the adjacent cell. There are thousands of records Is there a way of selecting and pasting only the cells that has data in it.. rather than selecting the whole column and pasting it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
| Select one of many clipboard item to paste into document | Excel Worksheet Functions | |||
| Lost my Paste | Excel Discussion (Misc queries) | |||
| Paste Special | Excel Worksheet Functions | |||
| excel - numbers as text | New Users to Excel | |||
Linear Mode
