Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE
     ❯   

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

Table Pivot

Table Pivot Intro

Excel Case

Case: Poke Mart Case: Poke Mart, Styling

Excel Functions

AND AVERAGE AVERAGEIF AVERAGEIFS CONCAT COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS IF IFS LEFT LOWER MAX MEDIAN MIN MODE NPV OR RAND RIGHT STDEV.P STDEV.S SUM SUMIF SUMIFS TRIM VLOOKUP XOR

Excel How To

Convert Time to Seconds Difference Between Times NPV (Net Present Value) Remove Duplicates

Excel Examples

Excel Exercises Excel Certificate

Excel References

Excel Keyboard Shortcuts


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 H1
  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.


×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
help@w3schools.com

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookie and privacy policy.

Copyright 1999-2024 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.