Question: how to copy excel sheet to pendrive?
Answer: Locate the folder that contains the Excel files, which is most likely the "My Documents" folder.
Right-click the Excel file and select the "Copy" option. ... 
Open the "Start" menu and click on the "E:" drive.