• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Not Able to Edit the Range of The Table

kelvin-lkh

New Member
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?




73048Not
 

Attachments

p45cal

Well-Known Member
Either:
Table Design then Resize Table
OR:
drag the grab handle at the bottom right of the table 2 columns to the right:
73109
 
Top