Q. What is the difference between a regular paste in Microsoft Excel and Paste Special? A. As an accountant, you know how to copy or cut and paste in Microsoft Excel. On PCs, it’s as simple as Ctrl+C ...

Alright, so here is a weird one that has hit me several times. Some hotkey (or combination of keys) while I am copying/pasting formulas in Excel basically 'locks' the formulas so they do not calculate ...

Well, as long as you don't mind manually propagating the formula in one direction, just go to a cell you want, highlight the text out of the formula box up top and hit ctrl-c, it does a text copy. Go ...