June 14, 2018

The neat thing about using the control and shift keys is that their function is similar throughout the computing Environment.

In Windows Explorer, holding down the ctrl key enables one to cherry pick multiple files or folders at the same time. Holding the shift key enab...

June 7, 2018

In previous Tips we’ve seen that across multiple platforms, including Windows and Excel, holding down the control key while dragging and dropping anything that can be dragged and dropped creates a copy instead of moving it, including Excel Sheets and Cells.

In other wor...

May 30, 2018

In the previous Tip we established that the use of the control key to Copy Files in the Windows environment has the same application when working with Sheets in Excel.

So, to create a copy of a sheet within or across workbooks, simply drag and drop the sheet while pres...

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 w...

Please reload

Please reload

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