Highlight the whole of Sheet1 by right clicking the empty box at the top
left next to Column A and Row1, select 'Copy'
Open Sheet2, hold down Shift and then click Sheet20,
Right click the same empty box and hit 'Paste'
Note that the sheet tabs need to be in numerical order to do this in this
way, or at least, Sheet1 needs to be first or last,
Regards,
Alan.
"BrianMultiLanguage" wrote in
message ...
I want to copy the data and format in sheet1 to sheet2-20 in the same
workbook.
I didn't find it in the help or in the online help.
Thanks