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


Upload your resume securely at https://www.dwsimpson.com
to be contacted when our jobs meet your skills and objectives.


Reply
 
Thread Tools Search this Thread Display Modes
  #91  
Old 02-29-2012, 07:52 PM
diegol diegol is offline
Member
 
Join Date: May 2002
Posts: 237
Default

Quote:
Originally Posted by llcooljabe View Post
From Microsoft's Excel Blog:

Keyboard shortcuts - Ctrl keys
Keyboard shortcuts - Function keys
Keyboard shortcuts - Miscellaneous

The comments also have some links to other sources.
Thanks for this!

My three picks to put into practice ASAP:

SHIFT+F2: adds or edits a cell comment
CTRL+SHIFT+O: Selects all cells that contain comments.
CTRL+SHIFT_: Removes outline border from selected cells
__________________
Diegol
Reply With Quote
  #92  
Old 04-26-2012, 08:07 PM
Noddy's Avatar
Noddy Noddy is offline
Member
 
Join Date: May 2007
Posts: 2,450
Default

Quote:
Originally Posted by Gedankenexperiment View Post
Mouse shortcuts!

Another not listed there, is that double clicking on the format paintbrush locks it in place until you click it again.
or press escape
__________________
Ridicule is the only weapon which can be used against unintelligible propositions. - Thomas Jefferson
Reply With Quote
  #93  
Old 04-26-2012, 08:10 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: 37,025
Default

"double clicking on the format paintbrush locks it in place "
I have never been able to get that to work. <sigh>
__________________
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 Apr 5, 2018.

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.
And this all purpose permanent quote:
Quote:
Originally Posted by Dr T Non-Fan View Post
Yup, it is always someone else's fault.
MORE:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #94  
Old 04-29-2012, 09:53 PM
Noddy's Avatar
Noddy Noddy is offline
Member
 
Join Date: May 2007
Posts: 2,450
Default

Quote:
Originally Posted by JMO View Post
"double clicking on the format paintbrush locks it in place "
I have never been able to get that to work. <sigh>
That's strange. Are you sure you're double clicking fast enough? Perhaps you might consider dialing down the double click speed a scosche.
__________________
Ridicule is the only weapon which can be used against unintelligible propositions. - Thomas Jefferson
Reply With Quote
  #95  
Old 04-29-2012, 10:06 PM
Noddy's Avatar
Noddy Noddy is offline
Member
 
Join Date: May 2007
Posts: 2,450
Default

Quote:
Originally Posted by JMO View Post
"double clicking on the format paintbrush locks it in place "
I have never been able to get that to work. <sigh>
Oh but there's this problem with 2007 and 2010.

http://answers.microsoft.com/en-us/o...5-504abe2b8db5

Answer 1 looks like a 'work-around' although alt e,s,t is paste formats anyway i will try tomorrow, fewer keystrokes, and 7 looks like it just may be the solution to your problem
__________________
Ridicule is the only weapon which can be used against unintelligible propositions. - Thomas Jefferson
Reply With Quote
  #96  
Old 01-11-2013, 05:41 PM
dumples dumples is offline
Member
CAS
 
Join Date: Sep 2003
Posts: 1,246
Default

Overall, I like what you did, but here's my take on your file.

This'll take an input of either a column or a number and tell you the corresponding number or column. It also handles 3 letter columns.
Attached Files
File Type: xlsm ColumnConverter2.xlsm (16.8 KB, 125 views)
Reply With Quote
  #97  
Old 01-14-2013, 01:56 PM
dancran1220's Avatar
dancran1220 dancran1220 is offline
Member
SOA
 
Join Date: Jul 2012
Posts: 4,957
Default

Quote:
Originally Posted by dumples View Post
Overall, I like what you did, but here's my take on your file.

This'll take an input of either a column or a number and tell you the corresponding number or column. It also handles 3 letter columns.
Yeah I like your version better. My original could take either a column or a number, just not from the same cell. IE: you can change the number value and it will change the letter value, or the other way around. I think your method of having only 1 cell open to edit makes more sense though.
Reply With Quote
  #98  
Old 01-14-2013, 02:17 PM
SpaceActuary's Avatar
SpaceActuary SpaceActuary is offline
Member
 
Join Date: Apr 2010
College: Drake U
Posts: 599
Default

Quote:
Originally Posted by dumples View Post
Overall, I like what you did, but here's my take on your file.

This'll take an input of either a column or a number and tell you the corresponding number or column. It also handles 3 letter columns.
Quote:
Originally Posted by dancran1220 View Post
Yeah I like your version better. My original could take either a column or a number, just not from the same cell. IE: you can change the number value and it will change the letter value, or the other way around. I think your method of having only 1 cell open to edit makes more sense though.
For one-off stuff like this, I prefer using the immediate window (Ctrl-G in the VB Editor). Once you have it open, you can type statements to have them executed immediately (thus the name), and also query values/properties by prefixing them with a question mark (?).

Get column number from letter:
Code:
?Range("BX1").Column
Get number of columns from range (as letters):
Code:
?Range("BX1:DZ1").Columns.Count
Get column letter from column number (remember that Cells -> (row, column)):
Code:
?Cells(1, 32).Address
Get column letter X columns to the left/right:
Code:
?Range("BX1").Offset( , 41).Address
__________________
And all this science, I don't understand; It's just my job five days a week...a rocket man, a rocket man...

"I'm from Iowa. I only work in space." - Adm. James T. Kirk
Reply With Quote
  #99  
Old 01-27-2013, 02:45 AM
bensonby2 bensonby2 is offline
Member
SOA
 
Join Date: Jan 2013
College: The Chinese University of Hong Kong
Posts: 92
Default

Has anyone got a full list of Excel shortcuts of Alt? They are the more important shortcuts to allow us to work fast. It'd better be those shortcuts compatible with Excel 2003 menu (which works in Excel 2007 and 2010 too). To name a few:

Alt+D+S => Sort
Alt+D+P => Pivot Table
Alt+O+H+U => Unhide Sheet
Alt+O+C+A => automatically adjust column width
Alt+O+H+R => rename sheet name
Alt+E+L => Delete Sheet
Alt+E+K => Edit Links
Alt+V+Z => Zoom

I am using a lot of Alt shortcuts since I worked using Excel 2003, but I haven't got a full list compiled. Does anyone have it?

If such list does not exist.. I might try to compile one.....
Reply With Quote
  #100  
Old 02-09-2013, 08:20 PM
Noddy's Avatar
Noddy Noddy is offline
Member
 
Join Date: May 2007
Posts: 2,450
Default

Quote:
Originally Posted by bensonby2 View Post
Has anyone got a full list of Excel shortcuts of Alt? They are the more important shortcuts to allow us to work fast. It'd better be those shortcuts compatible with Excel 2003 menu (which works in Excel 2007 and 2010 too). To name a few:

Alt+D+S => Sort
Alt+D+P => Pivot Table
Alt+O+H+U => Unhide Sheet
Alt+O+C+A => automatically adjust column width
Alt+O+H+R => rename sheet name
Alt+E+L => Delete Sheet
Alt+E+K => Edit Links
Alt+V+Z => Zoom

I am using a lot of Alt shortcuts since I worked using Excel 2003, but I haven't got a full list compiled. Does anyone have it?

If such list does not exist.. I might try to compile one.....
Alt dff - data filter
Alt dfs - data filter show all
Alt eaa - clear all
Alt eaf - clear formats
Alt ir - insert row
Alt ic - insert column
Alt tpp - protect/unprotect sheet
Alt tpw - protect/unprotect wb
Alt esv - edit paste special values
Alt esf - edit paste special formula
Alt est - edit paste special formats

I found this list
http://www.quepublishing.com/article...13798&seqNum=3
__________________
Ridicule is the only weapon which can be used against unintelligible propositions. - Thomas Jefferson
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 10:33 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, 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.40496 seconds with 10 queries