| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill bar
I need to paste the following range: into consecutive cells:
=a1,=a4,=a7, =a10 down to about =a1230. When I use the fill handle after about 3 cells, Excel doesn't seem to understand that I want the cell reference sequence to increment by 3 each time. Is there a way to make that happen? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fill bar
Hi!
Try this: =INDEX(A:A,((ROWS($1:1)-1)*3)+1) Drag copy down as needed. Biff wrote in message oups.com... I need to paste the following range: into consecutive cells: =a1,=a4,=a7, =a10 down to about =a1230. When I use the fill handle after about 3 cells, Excel doesn't seem to understand that I want the cell reference sequence to increment by 3 each time. Is there a way to make that happen? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| Fill Effects on Fill Color | Excel Discussion (Misc queries) | |||
| Fill handle formula | Excel Worksheet Functions | |||
| How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
| Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
Linear Mode
