Here’s a quick keyboard tip, instead of copying and pasting the same information in multiple cells (too many steps!), try the following.
- Pre selecting the cells you want to enter data in.
- Enter the data – BUT instead use the Ctrl + Enter keyboard shortcut to confirm the data. This will duplicate your data entry to every cell you have selected.
The toughest part of this shortcut is remembering to use it!