Incoming SA. Just bought a Logitech G815 and plan on using the dedicated macro keys for saving excel keyboard shortcuts. Was wondering what you find you use the most. First add was special paste. Thanks!
| +227 | Coverage Banking is Paradise | 29 | 5d |
| +97 | London Recruiting is Paradise | 42 | 11h |
| +75 | My Motivation Is At An All Time High | 13 | 3d |
| +68 | UBS preparing for a October Layoff Massacre | 30 | 25m |
| +59 | Are Canadians still get jobs in the US? | 41 | 11h |
| +46 | Is 7 years in banking enough to retire, or am I delusional? | 25 | 1h |
| +34 | Do actual investment bankers despise IB TikTokers as much as I think they do? | 22 | 1h |
| +33 | MM IB --> NYC IB? | 17 | 15h |
| +25 | Work and Suicide | 15 | 5h |
| +24 | Negotiating VP Sign-On Bonus (NOT Tied to Deferred Comp)? | 22 | 5h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
alt, e, s - paste special menu crtl + [ or ] - trace precedents and dependents
I use alt shortcuts for almost everything....
If there is one thing you could add it would be to write a macro for “Center Across Selection” ... do this instead of merge and center. I have a shortcut set up for it but you could add it to your keyboard macro list.
If you have the developer ribbon click into and select “record macro” ... save it in your Personal Workbook, should have this option from the drop down.
Make sure you only have one cell selected prior to clicking record... once you click record, navigate to the home ribbon and click into the alignment options, choose “center across selection” and then click ok. Stop recording the macro.
it should be saved as whatever shortcut you selected prior to recording. I used crtl + m for mine, but you could really use anything that isn’t being used.