Tables can be reversed and converted back to range.
Tables can be converted to ranges by selecting a cell in the table range and clicking on the Convert to Range command.
The command to convert to range is found in the Table Design tab, in the Tools group.
Example - Convert Table to Range
Type or copy the values to follow the example.
Example
text
Name Type 1 Type 2 HP Attack Defense
Abra Psychic 25 20 15
Kadabra Psychic 40 35 30
Alakazam Psychic 55 50 45
Machop Fighting 70 80 50
Machoke Fighting 80 100 70
Machamp Fighting 90 130 80
Bellsprout Grass Poison 50 75 35
Weepinbell Grass Poison 65 90 50
Victreebel Grass Poison 80 105 65
Tentacool Water Poison 40 40 35
Tentacruel Water Poison 80 70 65
Geodude Rock Ground 40 80 100
Graveler Rock Ground 55 95 115
Golem Rock Ground 80 120 130
Ponyta Fire 50 85 55
Convert the range into a table.
-
Select a cell in the table range (
A1:F16) -
Click the Design Table tab ()
-
Click the Convert to Range command ()
The table is now converted into a range and it no longer has the table options available.
Note: The cell formatting is kept for the range after the conversion.