Excel 2010/2007: Convert text to a table or vice versa (via: Word – Office.com)
Posted by jpluimers on 2012/05/21
The introduction of the Ribbon in Office 2007 and 2010 often makes me ask “why are things so complicated now, that were so easy until Office 2003”.
One of the things that were very close together in Word 2003, was converting text to and from tables: they were in adjecent menu items.
Convert text to a table
- Tab Insert,
- Group Tables,
- click Table,
- then click Convert Text to Table.
Of course the keyboard shortcuts are “easy” to remember: Alt, N, T, V
Convert a table to text
- When you have a (portion of a) table selected, you get a new contextual tab set called Table Tools.
- Tab Layout,
- Group Data,
- click Convert to Text.
Of course the keyboard shortcuts are “easy” to remember: Alt, J,L, V
via: Convert text to a table or vice versa – Word – Office.com.
Naming of ribbon UI elements