|
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 |
Shortcut to switch from "fill down" to "copy" with mouse drag
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 |
Shortcut to switch from "fill down" to "copy" with mouse drag
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 |
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 |
| All times are GMT +1. The time now is 04:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com