Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
table range

ResolvedVersion 2007

Akeem has attended:
Excel Advanced course
Excel Intermediate course

Table Range

How do you change a table range?

RE: Table Range

Hello Akeem

Thank you for your question and welcome to the forum.

You can change a table range by either using the small blue handle that appears at the bottom right of the table, and drag it to include the cells you wish to have within the table range.

Or you can click in the table, go to Table Tools - Design ribbon and click Resize Table. Then select the range of cells the table refers to; click OK.

Kind regards
Amanda

Tue 3 Feb 2009: Automatically marked as resolved.

Excel tip:

Moving between Worksheets without using the mouse

Use the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys.

'Ctrl+PgDn' will move to the right and 'Ctrl+PgUp' will move to the left one worksheet at a time.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.