Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I copy cells and skip lines?
I want to copy a relative formula from cell A1 to cells A3, A5, A7,.... A3001.
In previous verisons I could highlight A1..A3000 select copy then go to A3 and select paste, and it would work. It would copy A1 to A3, then A2 to A4, then A3 to a5, all the way down to a3001. This no longer works. How can I quickly do this? |
#2
|
|||
|
|||
I don't understand exactly what you're describing that you did before, but
if you're looking to copy your relative formula to every other row, try this: Enter your formula in A1 and A3. Select A1 to A4. Click the fill handle of the 4 row selection and drag down to copy as needed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "con_jon" wrote in message ... I want to copy a relative formula from cell A1 to cells A3, A5, A7,.... A3001. In previous verisons I could highlight A1..A3000 select copy then go to A3 and select paste, and it would work. It would copy A1 to A3, then A2 to A4, then A3 to a5, all the way down to a3001. This no longer works. How can I quickly do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Skip blank cells in diagrams | Charts and Charting in Excel | |||
Counting nonblank and non white space cells | Excel Worksheet Functions | |||
Skip multiple blanks | Excel Discussion (Misc queries) | |||
how to skip the blank cells | Excel Discussion (Misc queries) | |||
Trouble with Averaging across several worksheets | Excel Worksheet Functions |