LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Shortcut to switch from "fill down" to "copy" with mouse drag

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I disable "cutting cells" and "drag and drop "in excel ? mwoody Excel Worksheet Functions 4 August 25th 08 03:53 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Shortcut key for "Paste Options" and "Error Checking" buttons? johndog Excel Discussion (Misc queries) 1 October 6th 06 11:56 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM


All times are GMT +1. The time now is 05:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"