Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training uk - Splitting cells
Hi Rebecca,
Thanks for your question.
In Excel, if you want to split cells, you need to uncheck MERGE cells.
You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.
If you find this feature more annoying than useful, you can turn it off by:
1. Going to Tools - Options.
2. Select the Edit tab.
3. Remove the tick from next to the "Enable AutoComplete for cell values" option.
4. Click OK.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
