Use F4 key to lock reference in a table

Last edited by The Microsoft Feedback Team 2 years ago

When you create formula with the named range of a table, you can't easily block the reference of your column. For instance, if you used the fill-handle to copy to the right, the reference of your column will change :( The only way to avoid that is to write [[column1]:[column1]] for all your reference (very annoying) So my suggestion to block the reference of a named range is to use the F4 key. Your formula is =SUM(table1[column1]) and after pressing F4 it becomes =SUM(table1[[column1]:[column1]])

We're considering this

Official Microsoft response

The Microsoft Feedback Team

Official Microsoft response

2 years ago

Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

2 comments

You must to comment

Andrew Moss1 year ago

0 reports0

Claire Squibb1 year ago

0 reports0

Last edited by Claire Squibb 1 year ago