View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RJ Dake RJ Dake is offline
external usenet poster
 
Posts: 2
Default 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