Excel Table Resizing

Table Resizing

The size of a table can be changed.

Resizing is to increase or decrease the range of the table.

There are three ways to resize a table

• Resize table command
• Drag to resize
• Adding headers

Resize Table Command

The resize table command allows you to change the size of the table by entering a range.

For example by entering A1:D10.

The command is found in the Ribbon under the Table Design tab.

Example - Resizing a Table

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

Copy Values

Convert the range into a table.

Lets resize the table from range A1:F12 to A1:F20

1. Select the table

2. Click the Table Design menu

3. Click the Resize Table command ()

Clicking the Resize Table command allows you to set a new range for the table.

4. Click the range input field

5. Type the new range, A1:F20

6. Click OK

Great! The table has been resized to from A1:F12 to A1:F20.

Drag to Resize

The table can be resized by dragging its corner.

Example - Dragging to Resize, Smaller

Change the tables size from A1:F12 to A1:D5

1. Press and hold the bottom right corner of the table ()

2. Move the pointer, marking the range A1:D5

The table range has been changed from A1:F12 to A1:D5.

Let's try to sort the Pokemon by their names to see what happens.

1. Click the filter option in A1

2. Sort by Ascending (A-Z)

The filter option only includes the Pokemon in the tables range (A1:A5). The connection to the cells outside of the table is broken.

Lets resize again, this time bigger.

Example - Dragging to Resize, Bigger

Change the tables size from A1:D5 to A1:G13

1. Press and hold the bottom right corner of the table ()

2. Move the pointer to mark A1:G13

The table range has been changed from A1:D5 to A1:G13.

The rest of the cells are now included again, and the connection between the cells is back.

Let's try to filter the Pokemon by their names to see what happens.

1. Click the filter option in A1

2. Sort by Ascending (A-Z)

Nice! The table has successfully sorted the Pokemon in the range A1:A12 by their names.

Oh wait. Something has changed. A new column (G) has appeared...

Increasing the table size will continue the formatting, formulas and add new columns.

The header name can be changed.

1. Double click G1

2. Delete the text

3. Type "Mighty" to G1

Another Example - Resize By Adding Columns

The table is automatically increased when new headers next to the table are added.

1. Type "Mew" to G1
2. Hit enter
3. Type "Two" to I1
4. Hit enter

New columns with appropriate rows are automatically added when new headers are typed.

In the next chapter you will learn about removing duplicates.