6 thoughts on “Wonky Keyboard Shortcut

  1. Jon Peltier

    That’s like the old days (Excel 97) and you copied a sheet. The VBA code name of the first sheet was Sheet1, of the first copy was Sheet11, the next Sheet111, etc, until you got an error because Sheet111111111111111… was longer than the allowed length of a sheet code name.

  2. sam

    Ctrl+Alt+L = Is the short cut for Re-apply
    Lets say you have a Date column in your table and you have filtered -Date Filters -> ThisWeek
    You close the file – go on a vacation for 2 weeks – come back open the file and say Ctrl+Alt+L – It will show us data of the week in which you have opened the file

  3. Jon Acampora

    I believe it has to do with the Solver add-in being enabled. When I have Solver enabled, the shortcut for re-apply changes to “Y12” for me. When Solver is disabled, the shortcut for re-apply is just “Y”.

    Not sure why it is displaying a lot of 2’s at the end though, but I agree with Ken’s long hold theory. That’s funny!

Leave a Reply

Your email address will not be published. Required fields are marked *

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    
    Markdown is turned off in code blocks:
     [This is not a link](http://example.com)

To create not a block, but an inline code span, use backticks:

Here is some inline `code`.

For more help see http://daringfireball.net/projects/markdown/syntax