Undocumented Excel key-bindings.

R

R Avery

Over time, I have found several key-bindings that access Excel
functionality that are not documented anywhere that I have looked. I do
not remember all of them offhand, but here are a few:

CTRL-SHIFT-< = Fill Down
CTRL-SHIFT-> = Fill Right
CTRL-ALT-L or R Arrow = Goto previous (next) selection area in multiple
area selection.
CTRL-Insert = Copy


Does anyone know of any other rarely used Excel keyboard bindings?
 
A

Auric__

Over time, I have found several key-bindings that access Excel
functionality that are not documented anywhere that I have looked. I do
not remember all of them offhand, but here are a few:

CTRL-SHIFT-< = Fill Down
CTRL-SHIFT-> = Fill Right
CTRL-ALT-L or R Arrow = Goto previous (next) selection area in multiple
area selection.
CTRL-Insert = Copy


Does anyone know of any other rarely used Excel keyboard bindings?

Ctrl + Delete = Cut
Shift + Insert = Paste

Those two, along with Ctrl + Insert (and doubtless others), date from
the DOS programs. I don't know if they're documented, but there's also:

Ctrl + D = Fill Down
Ctrl + R = Fill Right
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top