By combining To Go Special with Ctrl+Enter, you can fill thousands of empty cells with the correct data in seconds. First, ...

There is nothing more frustrating than when someone pastes a value on top of a formula in your spreadsheet. This can ruin a beautiful excel model. And it can take awhile to fix because you have to ...