Resolved: How do the Xs help you go faster to the bottom of your sheet as you say?
Can you please explains how the x strings in the end of the columns helps you get faster?
4 answers ( 1 marked as helpful)
You need to use the Ctrl + Down Arrow shortcut to go to the end of the table. Then for the rows to be filled you add 'x'. Ctrl + Up Arrow would allow you to go to the top of the table. Afterwards, you can Copy and use Ctrl + Shift + Down Arrow to paste the formula for the whole range. This allows you to get to the bottom of a very large table much faster. That's very useful in practice. Hope this helps! Please let me know if you need me to clarify further.
Thanks for the feedback. I also use another trick Ctrl + right Click in the corner
Submit an answer
Resolved: How did you select all the table rows and columns in one click?