Not Able to Edit the Range of The Table

[kelvin-lkh]

Hi Coach,

I want to expand the range of my table to 2 additional Columns, Col Z and Col AA. But the 'Refer to' in the below is greyed out so not able to edit.

Can you pls advice is it due to Table is locked from modification? How am I able to expand the range?




Not

 

[pecoflyer]

Post a sample sheet. Pictures are useless to work with

 

[kelvin-lkh]

Hi, I have attached the file as below. Thanks for the advice in advance.

 

[vletm]

kelvin-lkh
Could You use something like below ... ?

 

[kelvin-lkh]

I have tried inserting a column(Col Z) via this method but the table 3 still not expanding it to Col Z.

 

[vletm]

kelvin-lkh
Before:


After added eg two columns as I wrote:

 

[p45cal]

Either:
Table Design then Resize Table
OR:
drag the grab handle at the bottom right of the table 2 columns to the right:

 

[kelvin-lkh]

Hi All,

Thanks a lot!! your solutions really helpful!!