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

DW Simpson Global Actuarial & Analytcs Recruitment
Download our 2015 Actuarial Salary Survey
now with regional salary information!


Reply
 
Thread Tools Display Modes
  #31  
Old 11-13-2008, 09:19 AM
JMO's Avatar
JMO JMO is offline
Carol Marler
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 34,984
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 Jan 13, 2017.

Spoiler:
I should keep these two permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
MORE:
All round good advice:
Quote:
Originally Posted by snikelfritz View Post
Don't live your life by other people's expectations.
Quote:
Originally Posted by Dr T Non-Fan View Post
If you feel you have to lie, then you're don't have enough integrity to be an actuary.
Quote:
Originally Posted by Westley View Post
"It seems" isn't really compelling for me.
Quote:
Originally Posted by JohnLocke View Post
The danger is in mistaking the stereotypes for reality itself and not simplifications of reality.
Quote:
Originally Posted by Maine-iac View Post
Your general claims settlement rule of thumb is that arson is not covered. Stupidity is.
Reply With Quote
  #32  
Old 11-13-2008, 09: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 10:16 AM..
Reply With Quote
  #33  
Old 11-14-2008, 09:41 AM
llcooljabe's Avatar
llcooljabe llcooljabe is offline
Member
CAS
 
Join Date: Aug 2002
Posts: 20,775
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, 10: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, 10:31 AM
llcooljabe's Avatar
llcooljabe llcooljabe is offline
Member
CAS
 
Join Date: Aug 2002
Posts: 20,775
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, 11: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, 06:39 PM
DownInTexas's Avatar
DownInTexas DownInTexas is offline
Member
SOA
 
Join Date: Jul 2008
Studying for modules
Favorite beer: Shiner
Posts: 4,327
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, 11: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, 10:10 AM
WellThen WellThen is offline
Member
 
Join Date: Dec 2006
Posts: 2,335
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, 11: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 04:25 AM.


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.42115 seconds with 10 queries