| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying Cells with Fill Handle
If you want "the number" to advance as you copy across, then don't put a $
in front of it, as in: =$A1*2 Regards, Fred "RRG" wrote in message ... Can anyone help? I am trying to copy cells across a row using the fill handle that are referencing another sheet down a column. I am placing a "$" in front of the letter as to not change it, but since I am copying across, the number will not change. Is there any way to tell Excel that i want the number to advance as I copy across? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying formulas with fill handle | New Users to Excel | |||
| Is there a keyboard shortcut to fill handle a large # of cells? | Excel Discussion (Misc queries) | |||
| How to copying conditional formatting using the fill handle. | Excel Discussion (Misc queries) | |||
| Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
| using the fill handle All the cells return the value of the first | Excel Worksheet Functions | |||
![Fred Smith[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
