Copy a sheet in Excel, using the Ctrl key

May 15, 2018

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

 

 

 

 

 

 

 

Share on Facebook
Share on Twitter
Please reload

Featured Posts

Excel Tip – Using the Format Painter multiple times

November 20, 2019

1/1
Please reload

Recent Posts