Hi I am trying to showe someone Autofill using Office 2007. When I run my
version of Excel i have 8 options including Fill Days, Weeks weekdays years,
but my collague doesn't have those options on his version of Excel 2007.
can anyone advise me why?

thanks

Alex

How are you and he popping up this menu? IOW, exact steps to repro.

--
Jim
"Alexey" wrote in message
...
| Hi I am trying to showe someone Autofill using Office 2007. When I run
my
| version of Excel i have 8 options including Fill Days, Weeks weekdays
years,
| but my collague doesn't have those options on his version of Excel 2007.
| can anyone advise me why?
|
| thanks
|
| Alex
|
|

Hi

Well I am entering date into cell, Selecting that cell and 12 rows below;
right clicking on Auto Fill menu that appears; selecting my choice.

He is in India, I am in UK, so I am not sure, but assuming the same, as we
are following the same set on instructions

I can't follow your steps because, after selecting the 13 cells, I do not
see an Auto Fill menu to right click on. I do this by dragging the fill
handle with the right mouse button. If by chance you're getting to this
same menu then it is indeed a puzzler why your friend in India does not at
least see the options to fill dates. Granted if the first cell does not
contain a date the date selections will be disabled, but he should at least
see them.

It's just a guess but as I had problems following your steps, he may too ;-)

--
Jim
"Alexey" wrote in message
...
| Hi
|
| Well I am entering date into cell, Selecting that cell and 12 rows below;
| right clicking on Auto Fill menu that appears; selecting my choice.
|
| He is in India, I am in UK, so I am not sure, but assuming the same, as we
| are following the same set on instructions
|
|
|

Maybe Alexey is using this, (from Help), which seems a long way round doing
what the drag handle will do in an instant.

To use the Fill command, do the following:
1.. Starting with the cell that contains the first date, select the range
of cells that you want to fill with the sequential list of dates.
2.. On the Home tab, in the Editing group, click Fill, and then click
Series.
Rob


"Jim Rech" wrote in message
...
I can't follow your steps because, after selecting the 13 cells, I do not
see an Auto Fill menu to right click on. I do this by dragging the fill
handle with the right mouse button. If by chance you're getting to this
same menu then it is indeed a puzzler why your friend in India does not at
least see the options to fill dates. Granted if the first cell does not
contain a date the date selections will be disabled, but he should at
least
see them.

It's just a guess but as I had problems following your steps, he may too
;-)

--
Jim
"Alexey" wrote in message
...
| Hi
|
| Well I am entering date into cell, Selecting that cell and 12 rows
below;
| right clicking on Auto Fill menu that appears; selecting my choice.
|
| He is in India, I am in UK, so I am not sure, but assuming the same, as
we
| are following the same set on instructions
|
|
|

Hi both - thanks for your posts and help:

below is the actual text that we are both using:

Start Excel 2007 by double-clicking the Excel icon or by using the Start
menu. When the Excel 2007 screen opens, make cell A2 the active cell and
enter the following date: 23/7/2006.

Place your mouse pointer on the bottom right corner of the cell and it will
turn into a thin cross (+). Hold your left mouse button and drag down the
first column, Auto Filling the dates as you go, (until row 14). When you
stop, notice the AutoFill option butt on at the lower right corner of the
last cell.



Click on the AutoFill options button to display its menu.


Click the radio button next to the Fill Years option.


You can see how the year has been automatically incremented by one for each
date cell.


I can only assume that my colleague in India is not using a date field.

A

I considered that but it doesn't really fit his description. He mentions a
right click for instance, and doesn't mention 'series' at all. For my money
he and his friend are having a 'failure to communicate' (obscure reference
to the movie Cool Hand Luke), but he appears to have ridden off into the
ether so we'll never know...<g

--
Jim
"RobN" wrote in message
...
| Maybe Alexey is using this, (from Help), which seems a long way round
doing
| what the drag handle will do in an instant.
|
| To use the Fill command, do the following:
| 1.. Starting with the cell that contains the first date, select the range
| of cells that you want to fill with the sequential list of dates.
| 2.. On the Home tab, in the Editing group, click Fill, and then click
| Series.
| Rob
|
|
| "Jim Rech" wrote in message
| ...
| I can't follow your steps because, after selecting the 13 cells, I do not
| see an Auto Fill menu to right click on. I do this by dragging the fill
| handle with the right mouse button. If by chance you're getting to this
| same menu then it is indeed a puzzler why your friend in India does not
at
| least see the options to fill dates. Granted if the first cell does not
| contain a date the date selections will be disabled, but he should at
| least
| see them.
|
| It's just a guess but as I had problems following your steps, he may too
| ;-)
|
| --
| Jim
| "Alexey" wrote in message
| ...
| | Hi
| |
| | Well I am entering date into cell, Selecting that cell and 12 rows
| below;
| | right clicking on Auto Fill menu that appears; selecting my choice.
| |
| | He is in India, I am in UK, so I am not sure, but assuming the same,
as
| we
| | are following the same set on instructions
| |
| |
| |
|
|
|
|