If you are new to Excel, you no doubt have already discovered the need to take a series of numbers created by formulas and convert them to fixed values. In other words, replace the questions with the answers. With no idea how to accomplish this, beginners usually spend great stretches of time retyping the numbers into the answer cells to make them “permanent”.
Eventually, someone who feels your pain turns you on to the technique of highlighting all of your formula cells, clicking Copy, then in the same cells clicking Paste Special…, Paste Link.
You could now not be more ecstatic. “This is going to save me sooooo much time”, you say to yourself.
Well, guess what. There’s an even FASTER way to accomplish this task. Try this out: