150 votes16 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
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.
John [MS XL]
An error occurred while saving the commentRAF commented
This is desperately needed! Relative table references are a joke! Also, like the ideas in the comments below:
Jan Karel Pieterse - Once absolute reference is in place, get rid of difference b/t dragging fill handle and copying and pasting.
Kenneth Barber - The notation for an absolute table reference should be more in line with the absolute cell reference (i.e. - use $$).
eugenio and Ryan - F4 can toggle between table, non-table, relative and absolute references.RAF supported this idea ·