SUBSCRIBE FOR FREE EXCEL TIPS

Keyboard Shortcuts (alt + Enter)

We can use the Wrap Text feature in Excel to display all cell content over multiple lines. At times though this does not have the completely desired effect. alt + Enter enables one to put a Line Break at the exact point required irrespective of the Column Width.

MS Excel Tip: Keyboard Shortcuts (Ctrl + Enter)

By default, when we edit a cell and press the Enter Key, Excel shifts the focus to the cell below and makes that the Active cell. If we want to replicate the cell that we’ve just edited, we then need to reselect the cell in order to do so. Holding down the Ctrl key when pressing Enter keeps the cell that we’re editing as the Active cell, so we no longer need to reselect it. This may only be one less click; but 1 becomes 2 which becomes 3 and before long we are far more efficient when working in Excel. Keyboard Shortcuts – Saving you time, saving you money, putting you first!

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

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

Email: info@summitsolutions.co.za 

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

2020 | Copyright | Summit Solutions