EXCEL TIPS

February 26, 2020

To copy a Range of Data to a new sheet, without having to resize all the Column Widths to how you had it in the original, use Paste Special > Column Widths.

There are 2 ways to do this.

Option 1: First Copy, then right click to get your Pop-up Menu. Hover over the Paste Special arrow (>) and click on the Column Widths icon.

Option 2: First do a Normal Copy (ctrl + C) and Paste (Ctrl + V). Then Paste the Column Widths over the top...

February 13, 2020

To mass change negative values to positive or visa versa, simply use the Multiply Paste Special Feature. The trick is that you have to create a temporary value of -1 in a separate cell first and then Copy and Paste Special this value over the data, using the Multiply option.

January 28, 2020

Un-beknown to most, when you insert a new column, the Format of the cells in the Column are of the cells in the Column on the Left. So, if you get a Date when you enter a number as with the example shown, you would have inserted the column to the right of a Date Formatted Field.

This can be useful if that was your intention, but most of the time it isn’t. To override this default, use the Insert Options (little Paintbrush) to c...

Please reload

Please reload

Please reload

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • improve my skills on microsoft excel
  • excel training for businesses
  • excel training help in Durban
  • learn the features of excel

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

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

2020 | Copyright | Summit Solutions