Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
And I just discovered the <ctrl drag version to "copy down" as well.
Thanks to each of you for the help!!! RJ -- Tech Coordinator / Educator "Sean Timmons" wrote: Well, can alternately just use the fil handle to drag, click on the pop box just right and select "Copy Cells" for same and "Fill Series" to increment... "Jacob Skaria" wrote: Fill down the same?? --Type in cell A1 ITC.01.02.01 --Select A1:A10 --Press Ctrl + D (to fill down) --Press Ctrl + R (to fill right if the seletion is to right columns in the same row) If this post helps click Yes --------------- Jacob Skaria "RJ Dake" wrote: 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 | |
|
|
![]() |
||||
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 |