Forum Discussion
Solved
What's the shortcut to quickly select entire data in same column without header?
Hi, Currently I am using XLOOKUP function where I need to pull the specific data from certain column. In the past, I would click on the first data cell and then press "Ctrl+Shift"Down Arrow" to q...
- The best thing to do is use the Table references instead of the row-column references. It is both fast and more robust in case the size of the table changes. i did this in answering your other question. So in your example here it would be Table1[people_fully_vaccinated_per_hundred]
What is really nice is that as you type Table1 is will show in the pop up info window and you hit tab to accept it, then hit "[" and the whole list of options for that table will show up and as you type "p" it filters down to 2 options, hit the down arrow to select the one you want and hit tab to accept, and finally type "]" to finish the reference.
The best thing to do is use the Table references instead of the row-column references. It is both fast and more robust in case the size of the table changes. i did this in answering your other question. So in your example here it would be Table1[people_fully_vaccinated_per_hundred]
What is really nice is that as you type Table1 is will show in the pop up info window and you hit tab to accept it, then hit "[" and the whole list of options for that table will show up and as you type "p" it filters down to 2 options, hit the down arrow to select the one you want and hit tab to accept, and finally type "]" to finish the reference.
What is really nice is that as you type Table1 is will show in the pop up info window and you hit tab to accept it, then hit "[" and the whole list of options for that table will show up and as you type "p" it filters down to 2 options, hit the down arrow to select the one you want and hit tab to accept, and finally type "]" to finish the reference.
Dear Mtarler,
Understood, thank you so much for your clear instructions, that makes sense and I will do that moving forward.
Kind regards,
Amy
Understood, thank you so much for your clear instructions, that makes sense and I will do that moving forward.
Kind regards,
Amy