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.

 

[Fluff]

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

I didn't know about the two you shared & just assumed that everyone knew about using Ctrl & drag.
I hate to think how many other shortcuts are out there, that I've never come across.

 

[Rick Rothstein]

The shortcut back to General format is Ctrl ~ not sure where that would be located on your keyboard layout

That is located in the shift position of the ` (that little mark is the backward apostrophe) key. So CTRL+SHIFT+` does in fact convert a short date to a number.

I hate to think how many other shortcuts are out there, that I've never come across.

You would think Microsoft would post them somewhere on one of their websites... not just for Excel, but for all of their products.

 

[Fluff]

You would think Microsoft would post them somewhere on one of their websites... not just for Excel, but for all of their products.

That would certainly be very helpful.

 

[hajiali]

Thank you all for the feed back. I just thought there might be a VBA code to magically make that happen but apparently I’ll have to use one of those methods.

 

[Rick Rothstein]

You did see Fluff's posting about holding down the CTRL key while you drag, right?