![]() |
|
#11
|
|||
|
|||
![]() Not a shortcut, but shows the results of the three ways to generate special symbols: the Excel's CHAR function, alt + 3 digit keypad, and alt + 4 digit keypad.
__________________
Blessed are the flexible, for they shall not be bent out of shape. ![]() |
#12
|
||||
|
||||
![]()
__________________
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 Nov. 20, 2018. Spoiler: |
#13
|
||||
|
||||
![]() Quote:
![]()
__________________
You move me, you move me, With your buildings and your eyes; autumn woods and winter skies You move me, you move me. Open sea and city lights, busy streets and dizzy heights |
#15
|
|||
|
|||
![]() If I hit "control [" on a cell which has the vlookup function, it takes me to the left most element of the vlookup function.
What I would like to do is go back to to the lookup table (the second element of the vlookup function). Is there a way I can do this w/o using the mouse (audit button etc) Thanks |
#16
|
||||
|
||||
![]() Quote:
|
#17
|
|||
|
|||
![]() Anyone know the shortcut key to make words in a cell "align left", "center" or "aligh right"?
|
#18
|
||||
|
||||
![]() I put the icons for those on my customized toolbar, so I have no idea what the shortcut key is. Sorry.
__________________
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 Nov. 20, 2018. Spoiler: |
#19
|
|||
|
|||
![]() I have not been able to find a simple shortcut for those items either.
I did create a macro for centering in my personal spreadsheet, and assigned it to a CTRL-key. That might be the simplest approach for you. Just create three macros, and the three CTRL-keys you assign to the macros could be lined up in a row, making it easy to remember left, center, right. |
#20
|
||||
|
||||
![]() You can create one macro to toggle between all 4. Just assign a CTRL key (I use CTRL SHIFT C) and this will toggle.
There's probably a more efficient way to code this, but whatever... Code:
Sub AlignText() If Selection.HorizontalAlignment = xlGeneral Then With Selection .HorizontalAlignment = xlLeft End With elseIf Selection.HorizontalAlignment = xlLeft Then With Selection .HorizontalAlignment = xlRight End With elseIf Selection.HorizontalAlignment = xlRight Then With Selection .HorizontalAlignment = xlCenter End With elseIf Selection.HorizontalAlignment = xlCenter Then With Selection .HorizontalAlignment = xlGeneral End With endif End Sub |
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|