Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Salary Surveys
Property & Casualty, Life, Health & Pension

Health Actuary Jobs
Insurance & Consulting jobs for Students, Associates & Fellows

Actuarial Recruitment
Visit DW Simpson's website for more info.
www.dwsimpson.com/about

Casualty Jobs
Property & Casualty jobs for Students, Associates & Fellows


Reply
 
Thread Tools Display Modes
  #11  
Old 02-16-2007, 03:49 PM
Mobile Actuary Mobile Actuary is offline
Member
 
Join Date: Sep 2001
Location: The Water Winter Wonderland
Posts: 533
Default Characters, Special

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.
Attached Files
File Type: zip CharSet.ZIP (16.3 KB, 875 views)
__________________
Blessed are the flexible, for they shall not be bent out of shape.
Reply With Quote
  #12  
Old 05-31-2007, 12:36 PM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 35,893
Default

More on shortcuts in non-actuarial topics.

Note especially post # 38.
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated July 21, 2017.

Spoiler:
I should keep these three permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
MORE:
Quote:
Originally Posted by Locrian View Post
I'm disappointed I don't get to do both.
Quote:
Originally Posted by PeppermintPatty View Post
It's SO much better to work for a good manager.
Quote:
Originally Posted by Patience View Post
slow down
Quote:
Originally Posted by whisper View Post
It is really easy to judge from an ill-informed, outside view.
Quote:
Originally Posted by Colonel Smoothie View Post
The ones who complain that they're too good for that kind of work really aren't that good.
Two really useful all-purpose responses. Use one or both:
Quote:
Originally Posted by JasonScandopolous View Post
To which I say: duh and lol.
Careers:
Quote:
Originally Posted by Colonel Smoothie View Post
actuarial isn't the only good career out there.
Reply With Quote
  #13  
Old 06-14-2007, 06:56 PM
Chief Petosky's Avatar
Chief Petosky Chief Petosky is offline
Member
 
Join Date: Oct 2005
Location: Location: Location
Favorite beer: BBC Bourbon Stout
Posts: 16,975
Default

Quote:
Originally Posted by Mobile Actuary View Post
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.
__________________
You move me, you move me, With your buildings and your eyes; autumn woods and winter skies
You move me, you move me. Open sea and city lights, busy streets and dizzy heights
Reply With Quote
  #14  
Old 06-15-2007, 08:59 AM
llcooljabe's Avatar
llcooljabe llcooljabe is online now
Member
CAS
 
Join Date: Aug 2002
Posts: 21,629
Default

You can format numbers as fractions.
Format/Cells/Number Tab/Fraction
__________________
www.GoodNewsNow.info
Propoganda
Reply With Quote
  #15  
Old 08-31-2007, 05:18 PM
Dog_Breath Dog_Breath is offline
 
Join Date: Jan 2004
Posts: 7
Default Short cut for vlookup

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
Reply With Quote
  #16  
Old 02-20-2008, 02:47 PM
llcooljabe's Avatar
llcooljabe llcooljabe is online now
Member
CAS
 
Join Date: Aug 2002
Posts: 21,629
Default

Quote:
Originally Posted by Dog_Breath View Post
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.
__________________
www.GoodNewsNow.info
Propoganda
Reply With Quote
  #17  
Old 03-19-2008, 10:16 PM
JustDropBy JustDropBy is offline
Member
 
Join Date: Dec 2007
Posts: 46
Default

Anyone know the shortcut key to make words in a cell "align left", "center" or "aligh right"?
Reply With Quote
  #18  
Old 03-20-2008, 07:24 AM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 35,893
Default

Quote:
Originally Posted by JustDropBy View Post
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.
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated July 21, 2017.

Spoiler:
I should keep these three permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
MORE:
Quote:
Originally Posted by Locrian View Post
I'm disappointed I don't get to do both.
Quote:
Originally Posted by PeppermintPatty View Post
It's SO much better to work for a good manager.
Quote:
Originally Posted by Patience View Post
slow down
Quote:
Originally Posted by whisper View Post
It is really easy to judge from an ill-informed, outside view.
Quote:
Originally Posted by Colonel Smoothie View Post
The ones who complain that they're too good for that kind of work really aren't that good.
Two really useful all-purpose responses. Use one or both:
Quote:
Originally Posted by JasonScandopolous View Post
To which I say: duh and lol.
Careers:
Quote:
Originally Posted by Colonel Smoothie View Post
actuarial isn't the only good career out there.
Reply With Quote
  #19  
Old 03-20-2008, 09:33 AM
TooOldForThis TooOldForThis is offline
Member
 
Join Date: Nov 2001
Posts: 115
Default

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.
Reply With Quote
  #20  
Old 03-20-2008, 10:51 AM
llcooljabe's Avatar
llcooljabe llcooljabe is online now
Member
CAS
 
Join Date: Aug 2002
Posts: 21,629
Default

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...
Code:
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
__________________
www.GoodNewsNow.info
Propoganda
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 08:42 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.41282 seconds with 10 queries