| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Issue with 'Fill Series' feature
It works ok for me.
- entered 3:30pm (in cell A1) and 4:30pm (cell A2) Those are not true Excel time values. A true Excel time value has a space before the AM/PM. Try entering them like this: 3:30 PM 4:30 PM -- Biff Microsoft Excel MVP "Sudesh" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Issue with 'Fill Series' feature
Biff - wonderful solution. It's working well. You are a 'guru'. Thanks for
your time. "T. Valko" wrote: It works ok for me. - entered 3:30pm (in cell A1) and 4:30pm (cell A2) Those are not true Excel time values. A true Excel time value has a space before the AM/PM. Try entering them like this: 3:30 PM 4:30 PM -- Biff Microsoft Excel MVP "Sudesh" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Issue with 'Fill Series' feature
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Sudesh" wrote in message ... Biff - wonderful solution. It's working well. You are a 'guru'. Thanks for your time. "T. Valko" wrote: It works ok for me. - entered 3:30pm (in cell A1) and 4:30pm (cell A2) Those are not true Excel time values. A true Excel time value has a space before the AM/PM. Try entering them like this: 3:30 PM 4:30 PM -- Biff Microsoft Excel MVP "Sudesh" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
| Why doesn't the automatic fill feature work in excel? | Excel Discussion (Misc queries) | |||
| Auto Fill Series issue... | Excel Discussion (Misc queries) | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
Linear Mode
