| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autopopulating formulass horizontally?
If I create the formula in A1: =Worksheet!I4 I want to drag this to the right to copy the formula to other cells to the right. By default, A2 would equal: =Worksheet!J4 If I procede the I4 with a $, I get the same value all accross: A2: =Worksheet!$I4 A3: =Worksheet!$I4 How do I get A2: =Workstheet!I5 A3: =Worksheet!I6 etc. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I sort horizontally? | Excel Discussion (Misc queries) | |||
| Display Horizontally | Excel Discussion (Misc queries) | |||
| Sort horizontally? | Excel Discussion (Misc queries) | |||
| Filter horizontally? | Excel Worksheet Functions | |||
| Autofilter horizontally? | Excel Discussion (Misc queries) | |||
Threaded Mode
