I'm using Excel 2010 and running into this strange issue: when doing Ctrl+c then Ctrl+v, it starts to automatically paste as value instead of keeping the formula. It started randomly acting up like this and don't know how to switch it back to normal...
Help pls??
P.S. also Ctrl+c and then Enter doesn't work - it just won't do anything instead of pasting normally...
Really appreciate it!
| +244 | UBS Layoffs (October 2026) | 71 | 1h |
| +110 | Do people still want to go PE? | 34 | 12h |
| +71 | UBS Tech layoff | 22 | 1h |
| +62 | Bloomberg - New UBS Investment Bankers See Smaller Pay Gain on Promotion | 15 | 23h |
| +46 | Think I'm fucking up my analyst years | 16 | 4d |
| +36 | What Differentiates the Best Analysts as AI Improves? | 9 | 21h |
| +33 | Lazard hirevue | 11 | 1d |
| +26 | Ambitious CC Student trying to break into IB | 14 | 6d |
| +23 | Quitting After First 4 months | 10 | 8h |
| +22 | Cornell Club T10 Rankings (UPDATED 10/2026) | 15 | 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.
Do you have two separate instances of excel open? That will do it.
try alt e s f
try 'paste special'
esbanker is right on - alt esf is the best practice, doesn't kill your formatting. Even better, macro it.
Aut nulla quibusdam eos ducimus. Odit vitae aspernatur praesentium voluptas fugiat voluptatem neque eius. Ut impedit dolorem vel cupiditate cum.
Totam omnis quo et voluptatem fugit eaque totam. Nam quas expedita omnis placeat libero. Voluptatibus consequuntur voluptatem amet natus deserunt ipsa et. Sunt excepturi nam dicta ut sint.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...