When I use the Drag the fill handle and I want to create a series of numbers following the pattern, the Auto Fill Option does not appear. How do I get the Auto Fill OPtion?
Go to File > Options > Advanced, scroll down to the "Cut, copy and paste" section and check the box to "Show Paste Options button when content is pasted"
Clear all worksheet filters, if applicable, and try again
