Copy a sheet in Excel, using the Ctrl key

To create a copy of an Excel Worksheet within the same workbook:

  1. Click on the Sheet tab and hold down the Ctrl key on your keyboard (a little plus sign should appear).

  2. With the ctrl key still pressed, drag and drop to the required location (can also be across workbooks) …

  3. … and an exact replica of the sheet will be created.

Featured Posts
Posts Are Coming Soon
Stay tuned...
Recent Posts
Search By Tags

Training Offices:


106 Johan Avenue, Sandton


1 Tamarind Close, Umhlanga


400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923


Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions