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!
| +365 | Don’t work at UBS - UBS Sucks | 34 | 12h |
| +326 | Article - UBS’ Investment Bank Keeps Losing Ground | 41 | 14h |
| +102 | Should My Intern Get a Return Offer? | 41 | 58m |
| +60 | When to Leave Office as Intern | 8 | 3d |
| +54 | Best IB Group Overall? | 30 | 10h |
| +39 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 3d |
| +33 | What do you say to ppl who don’t know EVR/LAZ/CVP/PJT | 28 | 23h |
| +33 | F*ck it I'm Going to Med School | 13 | 5h |
| +31 | STEM student lost in London IB recruiting | 17 | 2d |
| +26 | [HELP REQUESTED]: Take A2A Promo or Go Corp Dev | 9 | 1h |
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.
Nihil dolores sit sed. Quo non atque dolores provident. Odio recusandae numquam aut minus. Modi ut repellat cupiditate ut esse corrupti qui. Error tempore non ab iure explicabo. Aut repellendus eum aut consectetur dolore natus.
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...