A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Auto Fill function in Excel 2007 not working properly



 
 
Thread Tools Display Modes
  #1  
Old January 16th 10, 08:13 AM posted to microsoft.public.excel.worksheet.functions
Raudawg
external usenet poster
 
Posts: 1
Default Auto Fill function in Excel 2007 not working properly

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,
etc.

What am I doing wrong?
Ads
  #2  
Old January 16th 10, 08:29 AM posted to microsoft.public.excel.worksheet.functions
Raudawg[_2_]
external usenet poster
 
Posts: 1
Default Auto Fill function in Excel 2007 not working properly

P.S. 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.

Steve
--
Steve "the Raudawg"


"Raudawg" wrote:

> 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,
> etc.
>
> What am I doing wrong?

  #3  
Old January 16th 10, 06:27 PM posted to microsoft.public.excel.worksheet.functions
CellShocked
external usenet poster
 
Posts: 277
Default Auto Fill function in Excel 2007 not working properly

On Sat, 16 Jan 2010 00:29:01 -0800, Raudawg > wrote:

>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?



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.
  #4  
Old January 16th 10, 09:32 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 22,911
Default Auto Fill function in Excel 2007 not working properly

To count autofiltered entries use the SUBTOTAL function.

=SUBTOTAL(3,range)

Will count only visible cells.

As far as autofilling goes.

I generally use this method.

Enter a number in a cell

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.


Gord Dibben MS Excel MVP

On Sat, 16 Jan 2010 00:29:01 -0800, Raudawg > wrote:

>P.S. 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.
>
>Steve


  #5  
Old September 9th 11, 08:02 PM posted to microsoft.public.excel.worksheet.functions
Linda Huntington
external usenet poster
 
Posts: 1
Default To count autofiltered entries use the SUBTOTAL function.

Regarding the reply from Gord Dibben MS Excel MVP


As far as autofilling goes.
I generally use this method.
Enter a number in a cell
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.

If you have an autofilter on, it will not fill. "Fill/Series" is grayed out. It works once you turn your filters off.



> On Saturday, January 16, 2010 3:13 AM Raudawg wrote:


> I cannot get the Auto Fill function to increase values in a series, and I
> feel certain I am 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,
> etc.
>
> What am I doing wrong?



>> On Saturday, January 16, 2010 3:29 AM Raudawg wrote:


>> P.S. 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.
>>
>> Steve
>> --
>> Steve "the Raudawg"
>>
>>
>> "Raudawg" wrote:



>>> On Saturday, January 16, 2010 1:27 PM CellShocked wrote:


>>> 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.



>>>> On Saturday, January 16, 2010 4:32 PM Gord Dibben wrote:


>>>> To count autofiltered entries use the SUBTOTAL function.
>>>>
>>>> =SUBTOTAL(3,range)
>>>>
>>>> Will count only visible cells.
>>>>
>>>> As far as autofilling goes.
>>>>
>>>> I generally use this method.
>>>>
>>>> Enter a number in a cell
>>>>
>>>> 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.
>>>>
>>>>
>>>> Gord Dibben MS Excel MVP




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
AUTO FIT not WORKING properly. Does not shrink row to fit BlueWolverine Excel Discussion (Misc queries) 2 October 26th 09 07:00 PM
Why isn't my paste function working properly in Excel? trainer07 Excel Discussion (Misc queries) 2 October 19th 07 06:09 PM
PAGE PREVIEW NOT WORKING PROPERLY IN EXCEL 2007 Scott Dixon Excel Worksheet Functions 0 July 4th 06 03:52 PM
Auto Filter not working properly Dale Fye Excel Discussion (Misc queries) 1 March 16th 05 01:29 PM
Replace function not working properly in Excel 2000 SP3 rgbytg Excel Worksheet Functions 5 November 11th 04 03:44 PM


All times are GMT +1. The time now is 02:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.