+ Reply to Thread
Results 1 to 3 of 3

Excel 2016 Autofill fails to show 'fill series' menu

  1. #1
    Registered User
    Join Date
    09-18-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    8

    Excel 2016 Autofill fails to show 'fill series' menu

    I wish to insert as simple series - 1,2,3, etc in column (with earlier versions of Excel it was simply edit-fiil-insert series).

    However, Autofill is enabled (as per instructions [+] below), but displays the Quick Analysis Tool menu and not the Fill Series menu.

    How is the Autofill 'Fill Series' option menu enabled ? TIA

    Dave.

    [+] 1.Click the File tab, and then click Options.
    2.Click Advanced, and then under Editing options, select or clear the Enable AutoComplete for cell values check box to turn automatic completion of cell values on or off.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Excel 2016 Autofill fails to show 'fill series' menu

    Hi Dave+,

    I have what you suggest above. I put a "1" in A1 and grab the bottom right corner (handle) of cell A1. As I pull it across it shows 1, but if I hold down the Ctrl key it does what I think you want.

    Read:
    https://support.office.com/en-us/art...2-35a236c5b5db

    Do you have stuff in those cells you are dragging over?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    09-18-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    8

    Re: Excel 2016 Autofill fails to show 'fill series' menu

    [previous replies posted but gone AWOL]

    Many thanks - not sure why the Quick Analysis Tool menu kept appearing, but no longer does.

    Dave.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  2. Replies: 2
    Last Post: 03-26-2017, 01:49 PM
  3. Replies: 8
    Last Post: 08-10-2016, 05:25 PM
  4. Shape fill from URL fails on Mac Excel 2011
    By SnugglesMcWal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2016, 09:00 PM
  5. Replies: 3
    Last Post: 11-11-2012, 06:24 PM
  6. [SOLVED] Can I use AutoFill or a formula to fill a series of letters?
    By tadpgk835 in forum Excel General
    Replies: 3
    Last Post: 04-28-2005, 10:06 AM
  7. [SOLVED] Filling in a Date Series using the Fill | Series menu command
    By Bob C in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2005, 08:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1