drag one value to default to Fill Series

[hajiali]

I'm needing the drag value option to always default to Fill Series specifically in range A3:A600. for ex. if user types 20 in A25 and drags down I want it to automatically do a fill Series. I'm aware that I can accomplish this by having 2 values and dragging it and also by selecting bottom of the drag values and select Fil Series However, be nice for it to do this with one value to make it more user friendly.

any suggestions is greatly appreciated.

 

[jasonb75]

You can change the step value in the series fill options, although I think that this is less user friendly than using 2 values to create the pattern.

Home tab > Fill > Series.

 

[hajiali]

thanks Jasonb75 I was looking for a VBA method more.

 

[jasonb75]

I don't see that there would be a practical way to do what you want. When I first read your post I was incorrectly thinking that you wanted a series increase of something other than 1.

As far as I'm aware, dates increase by 1 day from a single cell and times increase by 1 hour. For anything other than that you need minimum 2 cells to create a series.

 

[Rick Rothstein]

As far as I'm aware, dates increase by 1 day from a single cell...

Putting two values in and dragging is still probably easiest, but going with your above statement... the OP could put his number in a cell, use the Cell Format drop down on the Ribbon (Home tab, Number panel) to change the format to Short Date, drag down and then use the drop down to change the format back to General.

 

[jasonb75]

I did have similar thoughts, Rick, but it didn't seem very user friendly.

use the Cell Format drop down on the Ribbon (Home tab, Number panel) to change the format to Short Date

For me, Ctrl # changes general to short date and Ctrl ~ (Shift Ctrl #) changes back to general, not sure if that is the same for all keyboard layouts / regional settings though.

 

[Rick Rothstein]

Not sure where you are located, but that worked for me (sort of) on my US locale computer. Since the # key is on my number 2 key, I had to use CTRL+SHIFT+2 to convert the number to a date; however, I could not find the keystroke combination to reverse it (CTRL+SHIFT+2 did not act a toggle).

 

[Fluff]

If the value should always increase by one, why not just hold down the Ctrl key as you drag the fill handle.

 

[Rick Rothstein]

If the value should always increase by one, why not just hold down the Ctrl key as you drag the fill handle.

Nothing like learning a new (to me) shortcut. Thanks!

 

[jasonb75]

however, I could not find the keystroke combination to reverse it (CTRL+SHIFT+2 did not act a toggle).

The shortcut back to General format is Ctrl ~ not sure where that would be located on your keyboard layout but for me (UK locale) they are both conveniently on the same key.

Nothing like learning a new (to me) shortcut. Thanks!

Why are there so many of us that don't know about such simple shortcuts