CTRL+D

[Guest]

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)

 

[Guest]

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

 

[Guest]

Thank you!

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

 

[Guest]

Thank you!

Fill Down (from the Edit>Fill menu)

 

[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

 

[Guest]

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...