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

Constants: This is the fastest way to audit a spreadsheet for errors. It finds every cell that contains a manually typed ...