Excel tips and other stuff
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.
mine just shows Y1
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.
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
It’s a new UI design to mimic the smart phone. That’s the indication you need a “long hold” on the 2, :p
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!
I have Solver diabled, it still shows Y12222…
Posting code or formulas in your comment? Use <code> tags!
Mail (will not be published) (required)