CTRL+D

[CMIConnie]

Can anyone please tell me what CTRL+D does in Excel 2000? I frequently use
CTRL+F for the find function, but sometimes accidentally hid D and the hour
glass comes up and I eventually have to force Excel to close and I loose all
my changes. Ugh!!! Thank you anyone

[Niek Otten]

Fill Down (from the Edit>Fill menu)

--
Kind regards,

Niek Otten

"CMIConnie" <[email protected]> wrote in message
news:[email protected]...
> Can anyone please tell me what CTRL+D does in Excel 2000? I frequently
> use
> CTRL+F for the find function, but sometimes accidentally hid D and the
> hour
> glass comes up and I eventually have to force Excel to close and I loose
> all
> my changes. Ugh!!! Thank you anyone

[SVC]

Ctrl + D means "fill down". Excel is apparently expecting to find something
in the cell and fill it down the column.

"CMIConnie" wrote:

> Can anyone please tell me what CTRL+D does in Excel 2000? I frequently use
> CTRL+F for the find function, but sometimes accidentally hid D and the hour
> glass comes up and I eventually have to force Excel to close and I loose all
> my changes. Ugh!!! Thank you anyone

[via135]

enter anything in.. say A1..!

now select a1:a10 or extend upto your wish!

now enter "ctrl+d"

you selection will be filled up with what you have typed in a1! that's all!

-via135

Can anyone please tell me what CTRL+D does in Excel 2000? I frequently use
CTRL+F for the find function, but sometimes accidentally hid D and the hour
glass comes up and I eventually have to force Excel to close and I loose all
my changes. Ugh!!! Thank you anyone

[CMIConnie]

Thank you!

"SVC" wrote:

> Ctrl + D means "fill down". Excel is apparently expecting to find something
> in the cell and fill it down the column.
>
> "CMIConnie" wrote:
>
> > Can anyone please tell me what CTRL+D does in Excel 2000? I frequently use
> > CTRL+F for the find function, but sometimes accidentally hid D and the hour
> > glass comes up and I eventually have to force Excel to close and I loose all
> > my changes. Ugh!!! Thank you anyone

[CMIConnie]

Thank you!

"Niek Otten" wrote:

> Fill Down (from the Edit>Fill menu)
>
> --
> Kind regards,
>
> Niek Otten
>
> "CMIConnie" <[email protected]> wrote in message
> news:[email protected]...
> > Can anyone please tell me what CTRL+D does in Excel 2000? I frequently
> > use
> > CTRL+F for the find function, but sometimes accidentally hid D and the
> > hour
> > glass comes up and I eventually have to force Excel to close and I loose
> > all
> > my changes. Ugh!!! Thank you anyone
>
>
>

[Dominic]

Connie,

As many have stated, Ctrl+d executes the "fill down" function.

Why this causes your machine to lock-up I don't know.

Since this happens more often than you'd like, you can record a macro (to do
nothing) and assign it the key combination, Ctrl+d, overriding the fill down
command. That way, you won't risk freezing Excel.

Of course, you won't have a short cut to fill down anymore... :-)


"CMIConnie" wrote:

> Can anyone please tell me what CTRL+D does in Excel 2000? I frequently use
> CTRL+F for the find function, but sometimes accidentally hid D and the hour
> glass comes up and I eventually have to force Excel to close and I loose all
> my changes. Ugh!!! Thank you anyone