| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut to switch from "fill down" to "copy" with mouse drag
I work extensively with "indicators" and "IDs" where a number can translate
into a series or it can be static for many cells. Is there a shortcut key I can hold to "fill down" the same information for many in a series and then let up to jump the sequence forward as it might normally. Look at the following to get an idea. ITC.01.02.01 ITC.01.02.02 ITC.01.02.02 ITC.01.02.02 ITC.01.02.02 ITC.01.02.03 ITC.01.02.04 ITC.01.02.05 ITC.01.02.05 ITC.01.02.05 ITC.01.02.05 ITC.01.02.06 -- Tech Coordinator / Educator |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I disable "cutting cells" and "drag and drop "in excel ? | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
