![]() |
|
#21
|
||||
|
||||
![]() 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. |
#22
|
|||
|
|||
![]() Quote:
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 |
#23
|
||||
|
||||
![]() 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. |
#24
|
|||
|
|||
![]() Phil, thank you for providing me with my new favorite Excel trick.
|
#25
|
|||
|
|||
![]() 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. |
#26
|
||||
|
||||
![]() Quote:
Quote:
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. |
#27
|
||||
|
||||
![]() Quote:
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 Apr 5, 2018. Spoiler: |
#28
|
||||
|
||||
![]() 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 |
#29
|
||||
|
||||
![]() 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 |
#30
|
|||
|
|||
![]() Quote:
|
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|