| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help.. Drag reference to the right does not work...
Hi,
I tried to drag the reference below for cell A1 through H1 but it doesn't work. It only repeats the range G2 - G5. No increment across to the right. =data!$G2 for A1 =data!$G3 for B1 =data!$G4 for C1 =data!$G5 for D1 it turns out... which i do not wish. =data!$G2 for E1 =data!$G3 for F1 etc What is the trick to fix it? Thanks!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| the drag feature in combining cells won't work | Excel Worksheet Functions | |||
| Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
| OFFSET using ADDRESS for the reference argument | Excel Worksheet Functions | |||
| Work book formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
