Tutorials References Exercises Videos Menu
Get Certified Website NEW Pro NEW

Excel Tutorial

Excel HOME Excel Introduction Excel Get Started Excel Overview Excel Syntax Excel Ranges Excel Fill Excel Move Cells Excel Add Cells Excel Delete Cells Excel Undo Redo Excel Formulas Excel Relative Reference Excel Absolute Reference Excel Arithmetic Operators Excel Parentheses Excel Functions

Excel Formatting

Excel Formatting Excel Format Painter Excel Format Colors Excel Format Fonts Excel Format Borders Excel Format Numbers Excel Format Grids Excel Format Settings

Excel Data Analysis

Excel Sort Excel Filter Excel Tables Excel Conditional Format Excel Highlight Cell Rules Excel Top Bottom Rules Excel Data Bars Excel Color Scales Excel Icon Sets Excel Manage Rules (CF) Excel Charts Excel Charts Customization

Excel Case

Case: Poke Mart Case: Poke Mart, Styling

Excel Functions


Excel Exercises

Excel Exercises Excel Certificate

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

Note: Resizing will continue formatting and formulas. This will be covered in a later chapter.

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

Copy Values

Convert the range into a table.

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

  1. Select the table
  1. Click the Table Design menu

  1. Click the Resize Table command ()

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

  1. Click the range input field
  1. Type the new range, A1:F20

  1. 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 ()
  1. Move the pointer, marking the range A1:D5

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

Note: Cells outside of the table range are no longer included in the table. The connection between the cells created by the table is broken and they no longer have the table formatting.

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

  1. Click the filter option in A1
  1. 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 ()
  1. 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
  1. 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.

Note: It will not overwrite the name for existing headers. It will use the value that is typed in the header cell.

The header name can be changed.

  1. Double click G1
  1. Delete the text
  1. 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.