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


Fill in a brief DW Simpson Registration Form
to be contacted when new jobs meet your criteria.


Reply
 
Thread Tools Display Modes
  #21  
Old 05-14-2008, 07:40 PM
Gates Is Antichrist's Avatar
Gates Is Antichrist Gates Is Antichrist is offline
Member
SOA AAA
 
Join Date: Feb 2002
Location: Hell
Favorite beer: Pacifico
Posts: 156
Default

Alignment, justification, etc.:

In pre-2007 (otherwise, you have my sympathies),
alt-O/E/{control-tab to Alignment}/alt-H/J/Enter
eventually gets 'er done, just to point out that it can be done from keyboard. Maybe all of you already knew this so forgive the thread-dumbing diversion if so; and I agree that something direct is desired.

How about decimal "upping" and "downing" - alt-O/E/{control-tab to Number}/alt-D/up/Enter ain't very prime time. Macro (via ctrl-shift-) or custom icon (via alt- accelerator) is all I know of.

TooOldForThis - are you referring to Control-Shift rather than Control keys? I'm just checking if I've missed something. Want to hear nerd/spazz? I have 24 Ctrl-Shifts. Ctrl-Shift-F and -O were too useful as is. If I find that I can do even more, I'll do even more.
__________________
______
ON STRIKE. Thomas Jefferson and I are on strike against AO over a little matter called the First Amendment and censorship against dissenting views. I hereby choose to toss my voluntary contributions into the Harbor rather than accede in slavery to the oppressor.
Reply With Quote
  #22  
Old 05-14-2008, 08:17 PM
JABA JABA is offline
Member
CAS
 
Join Date: Jul 2004
Location: Seattle
Studying for no more exams!
Favorite beer: Any ale (but not IPA's)
Posts: 32
Default

Quote:
Originally Posted by Maxprime View Post
Key Description
CTRL+( Unhides any hidden rows within the selection.
CTRL+) Unhides any hidden columns within the selection.
I tried this and apparently
CTRL+SHIFT+( Unhides any hidden rows within the selection.
CTRL+SHIFT+) Unhides any hidden columns within the selection
and
CTRL+( Hides any rows within the selection.
CTRL+) Hides any columns within the selection
__________________
JABA ~ Just Another Bored Actuary
Reply With Quote
  #23  
Old 05-14-2008, 11:28 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

Similarly to hiding / unhiding rows, select some rows (or a range of cells over more than one row) and try
SHIFT ALT RightArrow

This "groups" the rows (puts a little [-] sign in the left margin; click it to roll it up and hide them.)

I prefer this method to ordinary "hide rows" because the [+] sign tells you that there are hidden rows lurking. Without that, it can be hard to notice the gap in row numbers or the one-pixel-thicker separator.

To ungroup the rows ("unhide"), use SHIFT ALT LeftArrow.
Reply With Quote
  #24  
Old 05-14-2008, 11:33 PM
..-. ..- -.-. -.- -.-- -- ..-. ..- -.-. -.- -.-- -- is offline
 
Join Date: Sep 2006
Posts: 15
Default

Phil, thank you for providing me with my new favorite Excel trick.
Reply With Quote
  #25  
Old 06-09-2008, 10:36 AM
tymesup tymesup is offline
Member
 
Join Date: Mar 2005
Posts: 854
Default

I believe I'm now flying Excel 2007 (how does one check this?)

In previous versions of Excel, I could insert a row with Alt I, R. It appears this still works. If I didn't already know this, how would I find it? After Alt I, a box shows up saying to continue the Office 2003 menu key sequence, but there's no dropdown box to help out.

Is there an intro to this version of Excel somewhere?

Thanks for any help.
Reply With Quote
  #26  
Old 06-09-2008, 11:20 AM
Gates Is Antichrist's Avatar
Gates Is Antichrist Gates Is Antichrist is offline
Member
SOA AAA
 
Join Date: Feb 2002
Location: Hell
Favorite beer: Pacifico
Posts: 156
Default

Quote:
Excel 2007
Quote:
If I didn't already know this, how would I find it?
You don't! This is the phrase the Office development team wants the whole world to ask! The mantra of Office 2007 is to simplify our lives by hiding features from us!

I've been [justifiably] loudly and vilely critical of Microsoft's ineptness in the past. But this is their master stroke. This interface change is THE absolutely most FOOLISH act in the history of Microsoft. Office development team: raise your bongs in victory. This is the ultimate in pot-headed stupidity.

The comments above are not my opinion. They are facts.
__________________
______
ON STRIKE. Thomas Jefferson and I are on strike against AO over a little matter called the First Amendment and censorship against dissenting views. I hereby choose to toss my voluntary contributions into the Harbor rather than accede in slavery to the oppressor.
Reply With Quote
  #27  
Old 06-09-2008, 11:36 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,499
Default

Quote:
Originally Posted by Gates Is Antichrist View Post
You don't! This is the phrase the Office development team wants the whole world to ask! The mantra of Office 2007 is to simplify our lives by hiding features from us!

I've been [justifiably] loudly and vilely critical of Microsoft's ineptness in the past. But this is their master stroke. This interface change is THE absolutely most FOOLISH act in the history of Microsoft. Office development team: raise your bongs in victory. This is the ultimate in pot-headed stupidity.

The comments above are not my opinion. They are facts.
Are you telling me that Excel 2007 doesn't support "Help About"?

Good grief, the stuff they make backward compatible, and then they pull a stunt like this. I hate M$.
__________________
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 Oct 13, 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.
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:
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.
Reply With Quote
  #28  
Old 11-12-2008, 08:24 PM
Gareth Keenan's Avatar
Gareth Keenan Gareth Keenan is offline
Member
CAS
 
Join Date: Feb 2006
Location: by a pretty big bay
Studying for #9
Favorite beer: butter
Posts: 1,280
Default Quick Copy values?

Does any one know if there is a quicker way to go to a cell, and using a combination of key strokes copy only the value of a cell?

Or,

Once I have copied a cell, or an array of cells, if there is a faster way to paste the values only other than the below sequence of keystrokes?

1) alt
2) e
3) s
4) v
5) enter?

It's very petty but when you paste a lot of values, it gets a little annoying.

Cheers!

Gareth Keenan
Reply With Quote
  #29  
Old 11-12-2008, 08:29 PM
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

It's not petty. I also know no shorter than alt-esv{enter}. My approach was to put this in personal.xls and gave it control-shift-V
Code:
Sub PasteValues() ' Control-Shift-V
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub
Reply With Quote
  #30  
Old 11-13-2008, 01:55 AM
dumples dumples is offline
Member
CAS
 
Join Date: Sep 2003
Posts: 1,244
Default

Quote:
Originally Posted by GatesIsAntichrist View Post
It's not petty. I also know no shorter than alt-esv{enter}. My approach was to put this in personal.xls and gave it control-shift-V
Code:
Sub PasteValues() ' Control-Shift-V
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub
Sure, now hit undo.
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 10:43 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.26291 seconds with 10 queries