Using x's in excel to speed up copy and paste.
How do you implement the x's to speed up copy and pasting?
3 answers ( 0 marked as helpful)
Hi Obioha,
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 for the whole range. Hope this helps!
Best,
Ned
If you don't put x's at the end of each column, the shortcut "ctrl + arrow down" will take you to the end of the sheet, row 1048676. If you put the x's the shortcut will take you to the x.
You can also fasten it by double-clicking on the selected cell's lower right corner.