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

Let’s say you have student information in a worksheet where students’ last names, first names, and ID numbers are in Column A. If you want their first name and last name to appear in Column B, you ...