Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Keyboard Map

VIEWS: 16 PAGES: 2

									Excel Macro Spreadsheet -- Keyboard Map
Original File location:                                   L:\Actuary\ssp\Excel_Macros.xls
Copy this file to:                                        C:\Program Files\Microsoft Office\Office\XLStart
 and it will open automatically when you start Excel (will be a hidden file - use "window-unhide" to unhide).
HOW TO READ THIS KEY - example: "Control + Shift + B" means hold down control and shift keys and hit the "b" key.
Shaded cells indicate macros in the above file. No shading means key is open or defaults to pre-existing Excel keystroke.

                                    Macro Name                        Control                        Macro Name
    Control +          (** denotes pre-existing Excel Keystroke)      + Shift +         (** denotes pre-existing Excel Keystroke)
         a                            ** SelectAll                           A                      APLPg1ToColumns
         b                                ** Bold                            B                 CellColorToggleBrightColors
         c                               ** Copy                             C                CellColorToggleLightestColors
         d                         Dollar0decimals                           D                        Dollar2decimals                    *
         e                       CenterAlignWithinCell                       E                    CenterAcrossColumns
         f                                ** Find                            F                         FreezePanes
         g                         DateAllNumbers                            G                       DateMonthLetters
         h                             ** Replace                            H                      FontSizeDecrease
         i                             ** Italicize                          I                     InsideBordersToggle
         j                        Comma0decimals                             J                       Comma2decimals                      *
         k                        CommaThousands                             K                       DollarThousands
         l                               LeftAlign                           L
         m                         CommaMillions                             M                       DollarMillions
         n                                ** New                             N                     InsertDateOfNow
         o                          ** File - Open                           O                   OutlineBordersToggle
         p                                ** Print                           P                      Percent1decimal
         q                       PageSetupLandscape                          Q                     PageSetupPortrait
         r                             RightAlign                            R                 PageBreakPreviewToggle
         s                           ** File - Save                          S                       ZoomIncrease
         t                             SetFooters                            T                      TextColorToggle
         u                            ** Underline                           U                 BottomLineBordersToggle
         v                               ** Paste                            V               CellColorToggleMediumColors
         w                          ** File - Close                          W                      WrapTextToggle
         x                                 ** Cut                            X                     MergeCellsToggle
         y                              ** Repeat                            Y                     FontSizeIncrease
         z                               ** Undo                             Z                      ZoomDecrease

                              ** Other Pre-Existing Excel Keystrokes you may find helpful:
                              Keystroke:                                         Does:
                            Control + Shift + %                                            Percent w/ 0 decimals
                             Control + Shift + ~                                General number format (e.g. 9876543.21)
                             Control + Shift + -                                            Remove all Borders
                            Control + Shift + &                                         Single Thin Outline border
                             Control + Shift + $                           Like Control + Shift + D (except negatives are in red)        *
                             Control + Shift + !                        Like Control + Shift + J (except negatives like "-3" not (3).)   *
                Control + ` (upper left on your keyboard)                                  View formulas toggle
                                Control + 5                                            Strikethrough, e.g. does this
                                Control + 8                                           Display or hide outline symbols
                                Control + 9                                                      Hide Rows
                             Control + Shift + (                                                Unhide Rows
                                Control + 0                                                     Hide Columns
                             Control + Shift + )                                              Unhide Columns
                                Control + 1                                                Format Cells window
         Alt + 5 while in "File-Open" or "File-Save As" windows                              Create New Folder
                                     F5                                 GoTo (alternative to control + g which is assigned a macro)
                                     F7                                                          Spell Check
                                     F12                                                        File - Save As
                                 Shift + F2                                               Insert or Edit Comment
                                 Shift + F10                                                Show shortcut menu
                                 Shift + F11                                                  Insert Worksheet
                                Control + F3                                                    Define Name
                         Control + Shift + <Enter>                       array formulas, e.g. {=+SUM(IF(C42:C46>3,D42:D46))}
                                   Alt + =                                                         AutoSum

    Macros developed by Liz Baumann (except those keystrokes already pre-existing in Excel, as noted by **).
L:\Actuary\ssp
7ec8cccf-3a4b-4a6d-9b53-3dc495298e85.xls <Keyboard Map>        Page 1 of 2                        CONFIDENTIAL           3/19/2010 12:53 AM
                                        Excel Macro Spreadsheet -- Macro descriptions
                                       Original File location:                                        L:\Actuary\ssp\Excel_Macros.xls
                                       Copy this file to:                                             C:\Program Files\Microsoft Office\Office\XLStart
                                                             Macro Name (** denotes pre-
                                       Keystroke                                                      Does what                                                Example          Special Notes
                                                                 existing Excel Keystroke)
                                       CTRL+D                         Dollar0decimals                 Format number in dollars with no decimals.               $9,876,543
                                       CTRL+SHIFT+D                   Dollar2decimals                 Format number in dollars with 2 decimals.              $9,876,543.21      CTRL+SHIFT+$ also does this
                                       CTRL+J                        Comma0decimals                   Format number in comma with no decimals.                 9,876,543
                                       CTRL+SHIFT+J                  Comma2decimals                   Format number in comma with 2 decimals.                 9,876,543.21      CTRL+SHIFT+! also does this
1. NUMBER FORMATTING




                                                                                                      Comma format in Thousands with one                                        This is formatting only; the number is not divided
                                       CTRL+K                       CommaThousands                                                                               9,876.5
                                                                                                      decimal place.                                                            by 1,000.
                                                                                                      Dollar format in Thousands with one decimal                               This is formatting only; the number is not divided
                                       CTRL+SHIFT+K                   DollarThousands                                                                           $9,876.5
                                                                                                      place.                                                                    by 1,000.
                                                                                                      Comma format in Millions with one decimal                                 This is formatting only; the number is not divided
                                       CTRL+M                         CommaMillions                                                                                9.9
                                                                                                      place.                                                                    by 1,000,000.
                                                                                                                                                                                This is formatting only; the number is not divided
                                       CTRL+SHIFT+M                     DollarMillions                Dollar format in Millions with one decimal place.           $9.9
                                                                                                                                                                                by 1,000,000.
                                       CTRL+SHIFT+%                         **                        Format number in percent with no decimals.              987654321%
                                       CTRL+SHIFT+P                  Percent1decimal                  Format number in percent with 1 decimal.               987654321.0%
                                       CTRL+SHIFT+~                         **                        General number format                                    9876543.21
                                       CTRL+G                        DateAllNumbers                   Date format displayed as e.g. 7/15/2003.                  7/15/2003
                                       CTRL+SHIFT+G                  DateMonthLetters                 Date format displayed as e.g. Jul-03.                       Jul-03
                                       CTRL+L                             LeftAlign                   Left-Align Text.                                    9876543.21            Other preexisting cell formatting does not change
2. ALIGNMENT




                                       CTRL+R                            RightAlign                   Right-Align Text.                                            9876543.21 Other preexisting cell formatting does not change
                                                                                                      Centers text within cell only (NOT across
                                       CTRL+E                      CenterAlignWithinCell                                                                      9876543.21        Other preexisting cell formatting does not change
                                                                                                      columns).
                                       CTRL+SHIFT+E               CenterAcrossColumns                 Centers text across highlighted columns.                       Other preexisting cell formatting does not change
                                                                                                      Toggle between Wrapping or Unwrapping               La La La La La La
                                       CTRL+SHIFT+W                   WrapTextToggle
                                                                                                      Text.                                               La La La La La
                                       CTRL+SHIFT+X                  MergeCellsToggle                 Toggle between Merging or Unmerging Cells.
                                                                                           Toggle through text colors: Blue, Green, Red,
                                       CTRL+SHIFT+T                   TextColorToggle
                                                                                           Brown, Black
                                                                                           Toggle through Brightest cell colors: Yellow,
                                       CTRL+SHIFT+B            CellColorToggleBrightColors
                                                                                           Bright Green, Turquoise, none
                                                                                           Toggle through Medium Light cell colors:
                                       CTRL+SHIFT+V           CellColorToggleMediumColors
                                                                                           Lavendar, Pink, Green, Aqua, Blue, none
3. LINES & COLORS & SIZE




                                                                                                      Toggle through Lightest cell colors: Tan, Light
                                       CTRL+SHIFT+C           CellColorToggleLightestColors
                                                                                                      Green, Light Turquoise, Light Yellow, none
                                       CTRL+SHIFT+-                           **                      Remove all Borders
                                                                                                      Toggle between 2 different Bottom Line
                                       CTRL+SHIFT+U             BottomLineBordersToggle
                                                                                                      borders (control+shift+- removes all borders).
                                       CTRL+SHIFT+&                           **                      Single Thin Outline border
                                                                                                      Toggle between 2 different Outline borders
                                       CTRL+SHIFT+O                OutlineBordersToggle
                                                                                                      (control+shift+- removes all borders).
                                                                                                      Toggle between different Inside borders or no
                                       CTRL+SHIFT+I                InsideBordersToggle
                                                                                                      Inside borders.
                                                                                                      Increases font size by 1 size if <20, 2 sizes if
                                       CTRL+SHIFT+Y                  FontSizeIncrease
                                                                                                      >20.
                                                                                                      Decreases font size by 1 size if <20, 2 sizes if
                                       CTRL+SHIFT+H                  FontSizeDecrease
                                                                                                      >20.
                                                                                                      Freeze or Re-Freeze panes where current cell
                                       CTRL+SHIFT+F                     FreezePanes
                                                                                                      is
                                                                                                      Toggles between normal view and view
                                       CTRL+SHIFT+R             PageBreakPreviewToggle
                                                                                                      showing page breaks
                                                                                                                                                                                Current path = path you see if you do File-Open ;
                                                                                                      Set footers to include filename, current path,                            this may differ from file's true path… in this case,
4. PAGE SETUP, VIEW OPTIONS, OTHERS




                                       CTRL+T                            SetFooters
                                                                                                      tab, page #, date, time, "CONFIDENTIAL".                                  do File-Open and find true path, cancel out, then
                                                                                                                                                                                run the macro.
                                                                                                      Liz's Page Setup #1: Landscape Orientation.
                                       CTRL+Q                     PageSetupLandscape                  (Also zooms 80%, columns 12 wide,
                                                                                                      SetFooters, etc.)
                                                                                                      Liz's Page Setup #2: Portrait orientation.
                                       CTRL+SHIFT+Q                  PageSetupPortrait                (Also zooms 80%, columns 12 wide,
                                                                                                      SetFooters, etc.)
                                       CTRL+SHIFT+Z                   ZoomDecrease                    Decreases zoom % by 5%, with limit of 50%.

                                       CTRL+SHIFT+S                    ZoomIncrease                   Increases zoom % by 5%, with limit of 200%.
                                                                                                      Inserts hardcoded current date and time in
                                       CTRL+SHIFT+N                  InsertDateOfNow                  chosen cell (formats with red italic font and          8/10/03 3:43 PM
                                                                                                      yellow background).
                                                                                                                                                                                Must open file as delimited so all in column A,
                                                                                                      Takes APL Page 1 Export (all in one column)
                                       CTRL+SHIFT+A                 APLPg1ToColumns                                                                                             then highlight all cells in that column that you
                                                                                                      and parses it to appropriate columns.
                                                                                                                                                                                want to parse, then run the macro.
                                                                                                                                                                                Must open file as delimited so all in column A,
                                                                                                      Same as "APLPg1ToColumns" except splits
                                       n/a                        APLPg1ToColumns_alt                                                                                           then highlight all cells in that column that you
                                                                                                      month and year to separate columns
                                                                                                                                                                                want to parse, then run the macro.

                                       Macros developed by Liz Baumann (except those keystrokes already pre-existing in Excel, as noted by **).

                                      L:\Actuary\ssp
                                      7ec8cccf-3a4b-4a6d-9b53-3dc495298e85.xls <Macro Descriptions>                               Page 2 of 2                                            CONFIDENTIAL           3/19/2010 12:53 AM

								
To top