LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Issue with 'Fill Series' feature

I use Excel 2007. My 'fill series' features is not functioning as expected.

- I formatted column A as Time
- entered 3:30pm (in cell A1) and 4:30pm (cell A2)
- after selecting both the cells and dragged
- the cells are filled with same values, however I want 5:00pm (cell A3) and
5:30pm (cell A4)
- the check box under MS Office Button/Excel Options/Advanced/Editing
Options/Enable AutoComplet is checked
- but if I enter 1 and 2 and dragg them, the correct series is placed in
other cells

Can somebody please help?

Many thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill Series Dates: not letting me change the series from year to m Mike Excel Discussion (Misc queries) 1 January 24th 08 05:08 PM
Why doesn't the automatic fill feature work in excel? JenniferO Excel Discussion (Misc queries) 4 May 10th 06 08:15 PM
Auto Fill Series issue... e3donald Excel Discussion (Misc queries) 3 April 26th 06 08:08 PM
Edit Fill Series - How do I fill using minute increments IUnknown Excel Discussion (Misc queries) 1 January 29th 06 12:50 PM
The fill feature in Excel that gives option to fill or copy KAHelman New Users to Excel 1 July 29th 05 07:47 PM


All times are GMT +1. The time now is 08:27 AM.

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

About Us

"It's about Microsoft Excel"