Wonky Keyboard Shortcut

Check out the keyboard shortcut for the Reapply button.

I don’t think I’ve ever used that button. If I need it, I think I’ll just use the mouse. Even I have limits.

6 Comments

  1. Gary k says:

    mine just shows Y1

  2. Jon Peltier says:

    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.

  3. sam says:

    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

  4. Ken Puls says:

    It’s a new UI design to mimic the smart phone. That’s the indication you need a “long hold” on the 2, :p

  5. Jon Acampora says:

    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!

  6. I have Solver diabled, it still shows Y12222…

Posting code or formulas in your comment? Use <code> tags!

  • <code lang="vb">Block of code goes here</code>
  • <code lang="vb" inline="true">Inline code goes here</code>
  • <code>Formula goes here</code>

Leave a Reply

You must be logged in to post a comment.

Here's how to update your reports of company and nearly any web data: