To do this, first, select the data, and press Ctrl+C to copy it. Next, head to the worksheet where you want to duplicate the ...

The Ctrl + End shortcut deserves special mention as it instantly takes you to the last cell containing data, which is perfect for quickly assessing the size of your dataset. If Ctrl + End takes you ...