By combining To Go Special with Ctrl+Enter, you can fill thousands of empty cells with the correct data in seconds. First, ...
When you want to fill a column in Excel with a given formula or value, you can do it the old fashioned way (select cells or the column header, CTRL+V to paste) or use can do it the much faster way by ...