Excel Shortcut List

[no driver]

Here's an article with some doubleclick shortcuts. I'd rather use the keyboard for some of these but it's nice to know they are there too:
http://chandoo.org/wp/2009/06/12/excel-mouse-tricks/

[JMO]

Originally Posted by no driver

Here's an article with some doubleclick shortcuts. I'd rather use the keyboard for some of these but it's nice to know they are there too:
http://chandoo.org/wp/2009/06/12/excel-mouse-tricks/

These are for Excel 2007, in case anybody was wondering. Some work in earlier versions as well.

[Noddy]

found this by accident a while back.

entered ---> displayed

6**6 ---> 6,000,000(depending on format)

used to use
6e6 ---> 6,000,000(depending on format)

but like using the numpad keys

[skittles]

does anyone know if there exists a shortcut for adding/removing decimal places (formatting)?

[JMO]

Originally Posted by skittles

does anyone know if there exists a shortcut for adding/removing decimal places (formatting)?

One of the default toolbars has a couple of icons, one that has a little arrow and .0 on the top line and .00 on the bottom. The other has the positions reversed and the arrow points the other way. These let you increase or decrease the number of decimals displayed in the currently select cell(s).

[skittles]

Thanks JMO, I knew about the toolbar, I meant keyboard shortcuts....

[ADoubleDot]

Originally Posted by skittles

Thanks JMO, I knew about the toolbar, I meant keyboard shortcuts....

I don't think it exists. I tried writing a macro for it awhile ago but that seems to be impossible too. It's about the only thing I ever use the mouse for when I am using excel anymore.

[GatesIsAntichrist]

If you could live with lame limited usability (unless you found the complete rules of format specifications - I haven't looked for it), you could build your own decimal increaser/decreaser with something roughly starting with

Sub macIncrDec()
  If InStr(Selection.NumberFormat, ".") = 0 Then
    Selection.NumberFormat = Selection.NumberFormat & "."
  Selection.NumberFormat = Selection.NumberFormat & "0"
End Sub

and assign those to your own toolbar icons with accelerator shortcuts.

My definition of lame might be something that's only usable 98% of the time or crashes over 0% of the time. But you might get 98% satisfaction with an expansion of something like the above, or 100% depending on how you use Excel.

[ADoubleDot]

It seems to never work for me. Even after I add the "end if" in the place where I assume you meant it to be. Thanks for the effort though.

[GatesIsAntichrist]

Originally Posted by ADoubleDot

It seems to never work for me.

Try

Sub macIncrDec()
  If Selection.NumberFormat = "General" Then
    Selection.NumberFormat = "0."
  Else
    If InStr(Selection.NumberFormat, ".") = 0 Then
      Selection.NumberFormat = Selection.NumberFormat & "."
    End If
  End If
  Selection.NumberFormat = Selection.NumberFormat & "0"
End Sub

and build from there if needed.

edit:All with Selection