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
  #31  
Old 11-13-2008, 08:19 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: 36,111
Default

I have a modified toolbar in Excel. One of the icons looks like a little clipboard with "12" on it. After copying a cell, I choose the destination cell and click that icon to paste value. Oh, and it works with undo.

I also have a paste format icon - the little clipboard shows "$I"

Another area has the stylized arrows to allow me to insert or delete cells, rows or columns.

While I was at it, I got rid of several icons on the default toolbars, since I never use them.

If you do certain things a lot in Excel, customized toolbars are definitely the way to go.
__________________
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 Aug 15, 2017.

Spoiler:
I should keep these four 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.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
MORE:
Quote:
Originally Posted by Woodrow View Post
Complementing your technical skills with social skills - whatever they are - will help your career. This is not a sign that the world is unjust.
Quote:
Originally Posted by Bro View Post
I recommend you get perspective.
Quote:
Originally Posted by Enough Exams Already View Post
Dude, you can't fail a personality test. It just isn't that kind of test.
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
Reply With Quote
  #32  
Old 11-13-2008, 08:24 AM
GatesIsAntichrist's Avatar
GatesIsAntichrist GatesIsAntichrist is offline
Member
SOA AAA
 
Join Date: Mar 2005
Location: Hell (on temporary assignment on Earth)
Favorite beer: New(fave)! Black'n'Tan
Posts: 206
Default

Quote:
Originally Posted by JMO View Post
If you do certain things a lot in Excel, customized toolbars are definitely the way to go.
And easy to put alt- keyboard shortcuts upon. Right click the icon, customize, right click again, and put ampersand in front of the desired letter.

EDIT: AFAIK you need to change to "text only(always)" or "image and text" for that. For compactness I use text only and a single letter name like &C or &G. (Alt-G is how I toggle design mode since I use controls on sheets.)

Last edited by GatesIsAntichrist; 11-13-2008 at 09:16 AM..
Reply With Quote
  #33  
Old 11-14-2008, 08:41 AM
llcooljabe's Avatar
llcooljabe llcooljabe is offline
Member
CAS
 
Join Date: Aug 2002
Posts: 21,692
Default

Personally, I find alt-esv enter very easy. I suspect the hunt-and-peck typists will not like this though.
__________________
www.GoodNewsNow.info
Propoganda
Reply With Quote
  #34  
Old 11-14-2008, 09:05 AM
sondhi's Avatar
sondhi sondhi is offline
Member
SOA
 
Join Date: Jul 2005
Studying for CSP
Favorite beer: Samuel Adams' Utopias
Posts: 59
Default

I have had this issue a number of times before as well. Sometimes, when I am working with Census files and I type in a formula (=B4/H6, say), instead of calculating the result, the formula stays and nothing happens. Is there a fix for this? If I repeat this in some other column, it works (on the same worksheet). Under the options, the calculations are set to automatic.

Any idea why this might be happening?

Thanks in advance.
Reply With Quote
  #35  
Old 11-14-2008, 09:31 AM
llcooljabe's Avatar
llcooljabe llcooljabe is offline
Member
CAS
 
Join Date: Aug 2002
Posts: 21,692
Default

not sure what is happening, but edit/clear/formats usually fixes it.
__________________
www.GoodNewsNow.info
Propoganda
Reply With Quote
  #36  
Old 11-14-2008, 10:11 AM
strategygamer's Avatar
strategygamer strategygamer is offline
Member
 
Join Date: May 2007
Studying for FAP
Posts: 2,765
Default

Quote:
Originally Posted by sondhi View Post
I have had this issue a number of times before as well. Sometimes, when I am working with Census files and I type in a formula (=B4/H6, say), instead of calculating the result, the formula stays and nothing happens. Is there a fix for this? If I repeat this in some other column, it works (on the same worksheet). Under the options, the calculations are set to automatic.

Any idea why this might be happening?

Thanks in advance.
sounds like the cell is formatted to text. it thinks you just want to see text there ("=b4/b6"), not the formula result.
__________________
http://www.boardgamegeek.com
Reply With Quote
  #37  
Old 01-23-2009, 05:39 PM
DownInTexas's Avatar
DownInTexas DownInTexas is offline
Member
SOA
 
Join Date: Jul 2008
Studying for modules
Favorite beer: Shiner
Posts: 4,452
Default

Instead of Alt-esv-Enter, I do right click-sv-enter. For the right click, I use the button between the Ctrl and windows button, not sure what it's called. It's at least one key stroke shorter.
Reply With Quote
  #38  
Old 02-05-2009, 10:00 PM
SouthernGeek's Avatar
SouthernGeek SouthernGeek is offline
Member
SOA
 
Join Date: Jul 2008
Studying for beer
Posts: 87
Blog Entries: 1
Default

ALT+ENTER seems to run the last selected macro out of the Macros dialog. Not sure if this works all the time but I discovered it by accident one day.
Reply With Quote
  #39  
Old 02-06-2009, 09:10 AM
WellThen WellThen is offline
Member
 
Join Date: Dec 2006
Posts: 2,344
Default

Quote:
Originally Posted by GatesIsAntichrist View Post
And easy to put alt- keyboard shortcuts upon. Right click the icon, customize, right click again, and put ampersand in front of the desired letter.

EDIT: AFAIK you need to change to "text only(always)" or "image and text" for that. For compactness I use text only and a single letter name like &C or &G. (Alt-G is how I toggle design mode since I use controls on sheets.)
Anyone have an idea as to why this doesn't work with paste values? Or if it does work, what did you name the icon and which letter is the ampersand in front of?
Reply With Quote
  #40  
Old 02-09-2009, 10:58 PM
Phil's Avatar
Phil Phil is offline
Site Supporter
Site Supporter
 
Join Date: Sep 2001
Location: not on board the Enterprise
Posts: 5,667
Default

Quote:
Originally Posted by SouthernGeek View Post
ALT+ENTER seems to run the last selected macro out of the Macros dialog. Not sure if this works all the time but I discovered it by accident one day.
Or you can use F4. F4 means "Repeat" and repeats the last action. Useful for deleting a lot of rows that are not contiguous, or for running the same macro on different sections of data.
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 09:43 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.46771 seconds with 10 queries