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?
5 answers ( 1 marked as helpful)
Hi Panagiotis,
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.
Best,
Ned
Thanks for the feedback. I also use another trick Ctrl + right Click in the corner
Sure, if that works for you. That's great!
I need to check it out:)
Hello, I understood how the x can help you navigate at the end of the table very quickly but can you help me out in understanding how the "copying formula till the end" works? I tried but I am making some mistake I guess.I am just reaching the end without the formula being copied.What am I missing?
