Excel Shortcut List

[diegol]

Originally Posted by llcooljabe

From Microsoft's Excel Blog:

Keyboard shortcuts - Ctrl keys
Keyboard shortcuts - Function keys
Keyboard shortcuts - Miscellaneous

The comments also have some links to other sources.

Thanks for this!

My three picks to put into practice ASAP:

SHIFT+F2: adds or edits a cell comment
CTRL+SHIFT+O: Selects all cells that contain comments.
CTRL+SHIFT_: Removes outline border from selected cells

[Noddy]

Originally Posted by Gedankenexperiment

Mouse shortcuts!

Another not listed there, is that double clicking on the format paintbrush locks it in place until you click it again.

or press escape

[JMO]

"double clicking on the format paintbrush locks it in place "
I have never been able to get that to work. <sigh>

[Noddy]

Originally Posted by JMO

"double clicking on the format paintbrush locks it in place "
I have never been able to get that to work. <sigh>

That's strange. Are you sure you're double clicking fast enough? Perhaps you might consider dialing down the double click speed a scosche.

[Noddy]

Originally Posted by JMO

"double clicking on the format paintbrush locks it in place "
I have never been able to get that to work. <sigh>

Oh but there's this problem with 2007 and 2010.

http://answers.microsoft.com/en-us/o...5-504abe2b8db5

Answer 1 looks like a 'work-around' although alt e,s,t is paste formats anyway i will try tomorrow, fewer keystrokes, and 7 looks like it just may be the solution to your problem

[dumples]

Overall, I like what you did, but here's my take on your file.

This'll take an input of either a column or a number and tell you the corresponding number or column. It also handles 3 letter columns.

[dancran1220]

Originally Posted by dumples

Overall, I like what you did, but here's my take on your file.

This'll take an input of either a column or a number and tell you the corresponding number or column. It also handles 3 letter columns.

Yeah I like your version better. My original could take either a column or a number, just not from the same cell. IE: you can change the number value and it will change the letter value, or the other way around. I think your method of having only 1 cell open to edit makes more sense though.

[SpaceActuary]

Originally Posted by dumples

Overall, I like what you did, but here's my take on your file.

This'll take an input of either a column or a number and tell you the corresponding number or column. It also handles 3 letter columns.

Originally Posted by dancran1220

Yeah I like your version better. My original could take either a column or a number, just not from the same cell. IE: you can change the number value and it will change the letter value, or the other way around. I think your method of having only 1 cell open to edit makes more sense though.

For one-off stuff like this, I prefer using the immediate window (Ctrl-G in the VB Editor). Once you have it open, you can type statements to have them executed immediately (thus the name), and also query values/properties by prefixing them with a question mark (?).

Get column number from letter:

?Range("BX1").Column

Get number of columns from range (as letters):

?Range("BX1:DZ1").Columns.Count

Get column letter from column number (remember that Cells -> (row, column)):

?Cells(1, 32).Address

Get column letter X columns to the left/right:

?Range("BX1").Offset( , 41).Address

[bensonby2]

Has anyone got a full list of Excel shortcuts of Alt? They are the more important shortcuts to allow us to work fast. It'd better be those shortcuts compatible with Excel 2003 menu (which works in Excel 2007 and 2010 too). To name a few:

Alt+D+S => Sort
Alt+D+P => Pivot Table
Alt+O+H+U => Unhide Sheet
Alt+O+C+A => automatically adjust column width
Alt+O+H+R => rename sheet name
Alt+E+L => Delete Sheet
Alt+E+K => Edit Links
Alt+V+Z => Zoom

I am using a lot of Alt shortcuts since I worked using Excel 2003, but I haven't got a full list compiled. Does anyone have it?

If such list does not exist.. I might try to compile one.....

[Noddy]

Originally Posted by bensonby2

Has anyone got a full list of Excel shortcuts of Alt? They are the more important shortcuts to allow us to work fast. It'd better be those shortcuts compatible with Excel 2003 menu (which works in Excel 2007 and 2010 too). To name a few:

Alt+D+S => Sort
Alt+D+P => Pivot Table
Alt+O+H+U => Unhide Sheet
Alt+O+C+A => automatically adjust column width
Alt+O+H+R => rename sheet name
Alt+E+L => Delete Sheet
Alt+E+K => Edit Links
Alt+V+Z => Zoom

I am using a lot of Alt shortcuts since I worked using Excel 2003, but I haven't got a full list compiled. Does anyone have it?

If such list does not exist.. I might try to compile one.....

Alt dff - data filter
Alt dfs - data filter show all
Alt eaa - clear all
Alt eaf - clear formats
Alt ir - insert row
Alt ic - insert column
Alt tpp - protect/unprotect sheet
Alt tpw - protect/unprotect wb
Alt esv - edit paste special values
Alt esf - edit paste special formula
Alt est - edit paste special formats

I found this list
http://www.quepublishing.com/article...13798&seqNum=3