ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   AutoFill feature not setup (https://www.excelbanter.com/setting-up-configuration-excel/207748-autofill-feature-not-setup.html)

veanmas

AutoFill feature not setup
 
It is my understanding that excel has this AutoFill feature which generates a
series of values into acent cells based on one cell using the fill handle.
For example, I type 'January' in A1, using the fill handle I drag to the righ
to B1 I should get 'February', then in C1 'March' and so on. This feature
doesn't seem to be set up on my 2007 version of excel. how do I turn it on?
Thanks

Sheeloo[_3_]

AutoFill feature not setup
 
It is available in Excel 2007 too. Try again and make sure the spelling is
correct.

I tested, just now, on my laptop and it worked fine.

Built-in lists in Excel 2007

1. Sun, Mon, Tue, Wed, Thu, Fri, Sat
2. Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
3. Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec
4. January, February, March, April, May, June, July, August, September,
October, November, December

For details see http://office.microsoft.com/en-us/ex...221421033.aspx.
It also tells you how to create your own custom lists.

"veanmas" wrote:

It is my understanding that excel has this AutoFill feature which generates a
series of values into acent cells based on one cell using the fill handle.
For example, I type 'January' in A1, using the fill handle I drag to the righ
to B1 I should get 'February', then in C1 'March' and so on. This feature
doesn't seem to be set up on my 2007 version of excel. how do I turn it on?
Thanks



All times are GMT +1. The time now is 03:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com