Results 1 to 3 of 3

Thread: AutoFill not working properly in Excel 2007

  1. #1
    Join Date
    Jan 2011
    Posts
    23

    AutoFill not working properly in Excel 2007

    I cannot get the Auto Fill function to increase values in a series, and I feel certain I'm doing it right: First, I tried typing a series of values in a column like this: Cell A1, I typed 1. Cell B1, I typed 2. Then, I selected both cells with the mouse, and then moved to the lower right corner of Cell B1 and left-clicked and held the mouse button down. Then I dragged the mouse button down several columns. The little pop-up message seemed to indicate that it was repeating 1, 2, 1, 2. When I released the mouse button, it had actually filled a 1 in each cell. After several unsuccessful attempts, I read online help and decided to try using a different method: the Fill tool function button on the toolbar. I could not seem to make that command work. The instructions in Online Help suggested I had a problem. I read, "1. On the Home tab, in the Editing Group, click Fill, and then click Series." When I clicked Fill, the Series command was grayed out, apparently regardless of what I had selected: a blank cell, a series of cells with a series of increasing values, or a combination of both.

    I began to suspect that my program settings were "messed up", so I clicked the Microsoft Office button, then the Excel Options button near the bottom right corner of the tab, as it instructed. I reviewed all the settings. Everything appears to be set properly. For example, Under Advanced options, "Enable fill handle and cell drag-and-drop" is checked, as is almost every other option on that tab. I wondered if there was an configuration problem with my software, so I even ran the online Microsoft Office Diagnostics. It found no problems, conflicts, tc. What am I doing wrong.

  2. #2
    Join Date
    Jun 2011
    Posts
    798

    Re: AutoFill not working properly in Excel 2007

    I had applied filters to the data sheet, and was working deliberately with one of the filters. I see that if I remove the filters, the function works. So that still leaves me with a question: If I want to count the number of entries in a filtered list, how do I do that? For example, should I use a formula with something like "COUNT" or "COUNTIF", rather than trying to simply enumerate the rows. If so, how do I do that. I will be eternally grateful for a correct, understandable answer.

  3. #3
    Join Date
    May 2011
    Posts
    448

    Re: AutoFill not working properly in Excel 2007

    Highlight the cells you are wanting data on, then look at the status line at the bottom of the worksheet window. There are several statistical figures there, including count. To count autofiltered entries use the SUBTOTAL function =SUBTOTAL(3,range). This will count only visible cells. As far as autofilling goes I generally use this method. Enter a number in a cell then right-click on fill handle and drag down. Release button and "Fill Series" to get a series of numbers. Otherwise you must have two numbers so Excel can see a pattern. Enter 1 in A1, 2 in A2 Select both cells and drag down. The series will fill.

Similar Threads

  1. Edit buttons not working properly in Excel
    By Shaina Na in forum Windows Software
    Replies: 2
    Last Post: 07-01-2012, 09:36 PM
  2. Radio Button is not working properly in Excel
    By Raju Chacha in forum Windows Software
    Replies: 2
    Last Post: 07-01-2012, 09:06 PM
  3. Pasting option is not working properly in Excel
    By Shaina Na in forum Windows Software
    Replies: 1
    Last Post: 06-01-2012, 10:59 PM
  4. Excel not working properly to open macros
    By Kungfu Pandey in forum Windows Software
    Replies: 1
    Last Post: 06-01-2012, 10:03 PM
  5. autofill is not working in firefox 5 and hotmail
    By JalB By in forum Technology & Internet
    Replies: 10
    Last Post: 15-09-2011, 11:00 AM

Tags for this Thread

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
  •  
Page generated in 1,711,645,195.30766 seconds with 17 queries