ExcelBanter - Duplication

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Duplication (https://www.excelbanter.com/excel-worksheet-functions/263180-duplication.html)

Lorenza@hsccs

Duplication

How do I duplicate a worksheet and contents 20 times in a workbook?

Dave Peterson

Duplication

just select the sheet
Edit|Move or copy sheet
Check copy

Or ctrl-click on the sheet tab and drag to the right or left.

Repeat 19 more times.

Lorenza@hsccs wrote:

How do I duplicate a worksheet and contents 20 times in a workbook?

--

Dave Peterson

All times are GMT +1. The time now is 12:06 PM.