Right mouse click on the worksheet name and choose the Move or Copy command.
Check the box Create a Copy. You can copy to the current workbook or another
workbook
Sheila


"Irish" wrote:

how can I copy a single worksheet to several other worksheets in the same
workbook or another workbook? I cannot paste as the paste command is grey'd
out when I select 2 or more worksheets.