This shortcut will copy from left to right. For adjacent cells, select one or more cells directly to the right of the data you want to copy and use the shortcut. For non-contiguous cells, select both source and target cells, then use the shortcut. This shortcut is especially handy in filtered lists, since it works with visible cells only.
Did you know you can use shortcuts to control the direction Excel moves when you press Enter? In this video, learn a boatload of shortcuts for entering data in Excel.
Download 200+ Excel Shortcuts
I don't think you understand how much your training has changed my life in terms of work efficiency and effectiveness not to mention minimizing my stress, anxiety and enabling me to shine in front of employers. -Veronika