Follow these methods to copy the names into a clipboard or notepad, or Excel file. 1] Using Windows Explorer Go to the folder in which you want to copy the names using Explorer.

Fortunately, Excel 2007 enables you to select all pages and copy formatting to all of them. This method allows you save precious time and ensure formatting is consistent across all sheets.