You can copy data to multiple worksheets by following these steps: 1  Select the worksheet that has the data you want to copy. 2  Select the worksheets to which you want to copy this data. You can do this by holding down the Ctrl key and clicking on the tabs of the desired worksheets.