| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drag to fill row with column values
In the sheet "Stats", there are columns of numbers, we'll say A1:A10,
that I would like to automatically put in a single row, we'll say A15:J15,using "=A1" and so on, and I'd like to do this many times. In A15 I put "=A1"....is there a keyboard shortcut that, when pressed while I drag to the right will put "=A2" in B15 instead of B2, and so on? Thanks to all. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
| if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
| What is keyboard shortcut equivalent to drag the fill handle | Excel Discussion (Misc queries) | |||
| How to avoid black shade fill on the from cell,when drag-and-drop | New Users to Excel | |||
| Drag values down cells | New Users to Excel | |||
Threaded Mode
