Actuarial Outpost

Actuarial Outpost (http://www.actuarialoutpost.com/actuarial_discussion_forum/index.php)
-   Software & Technology (http://www.actuarialoutpost.com/actuarial_discussion_forum/forumdisplay.php?f=17)
-   -   Excel Shortcut List (http://www.actuarialoutpost.com/actuarial_discussion_forum/showthread.php?t=47963)

no driver 06-12-2009 05:23 PM

mouse shortcuts
 
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 06-16-2009 08:47 AM

Quote:

Originally Posted by no driver (Post 3709749)
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 06-24-2009 06:01 PM

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 06-24-2009 06:21 PM

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

JMO 06-25-2009 08:34 AM

Quote:

Originally Posted by skittles (Post 3731591)
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 06-25-2009 09:42 AM

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

ADoubleDot 06-25-2009 10:54 AM

Quote:

Originally Posted by skittles (Post 3732163)
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 06-25-2009 11:38 AM

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
Code:

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 06-25-2009 11:53 AM

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 06-25-2009 11:58 AM

Quote:

Originally Posted by ADoubleDot (Post 3732646)
It seems to never work for me.

Try
Code:

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 :oops:


All times are GMT -4. The time now is 12:58 PM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

Page generated in 0.39997 seconds with 9 queries