Excel Shortcut List

[Mobile Actuary]

Not a shortcut, but shows the results of the three ways to generate special symbols: the Excel's CHAR function, alt + 3 digit keypad, and alt + 4 digit keypad.

[JMO]

More on shortcuts in non-actuarial topics.

Note especially post # 38.

[Chief Petosky]

Originally Posted by Mobile Actuary

Not a shortcut, but shows the results of the three ways to generate special symbols: the Excel's CHAR function, alt + 3 digit keypad, and alt + 4 digit keypad.

What do they have against thirds ... I need a "1/3" and a "2/3" character. They have fourths but no thirds.

[llcooljabe]

You can format numbers as fractions.
Format/Cells/Number Tab/Fraction

[Dog_Breath]

If I hit "control [" on a cell which has the vlookup function, it takes me to the left most element of the vlookup function.

What I would like to do is go back to to the lookup table (the second element of the vlookup function). Is there a way I can do this w/o using the mouse (audit button etc)

Thanks

[llcooljabe]

Originally Posted by Dog_Breath

If I hit "control [" on a cell which has the vlookup function, it takes me to the left most element of the vlookup function.

What I would like to do is go back to to the lookup table (the second element of the vlookup function). Is there a way I can do this w/o using the mouse (audit button etc)

Thanks

If you use named ranges in your vlookups, then simply hit F5 and pick from the list. But I'm sure you knew that already.

[JustDropBy]

Anyone know the shortcut key to make words in a cell "align left", "center" or "aligh right"?

[JMO]

Originally Posted by JustDropBy

Anyone know the shortcut key to make words in a cell "align left", "center" or "aligh right"?

I put the icons for those on my customized toolbar, so I have no idea what the shortcut key is. Sorry.

[TooOldForThis]

I have not been able to find a simple shortcut for those items either.

I did create a macro for centering in my personal spreadsheet, and assigned it to a CTRL-key.

That might be the simplest approach for you. Just create three macros, and the three CTRL-keys you assign to the macros could be lined up in a row, making it easy to remember left, center, right.

[llcooljabe]

You can create one macro to toggle between all 4. Just assign a CTRL key (I use CTRL SHIFT C) and this will toggle.

There's probably a more efficient way to code this, but whatever...

Sub AlignText()
     If Selection.HorizontalAlignment = xlGeneral Then
          With Selection
               .HorizontalAlignment = xlLeft
          End With
     elseIf Selection.HorizontalAlignment = xlLeft Then
          With Selection
               .HorizontalAlignment = xlRight
          End With
     elseIf Selection.HorizontalAlignment = xlRight Then
          With Selection
               .HorizontalAlignment = xlCenter
          End With
     elseIf Selection.HorizontalAlignment = xlCenter Then
          With Selection
               .HorizontalAlignment = xlGeneral
          End With
     endif
End Sub