Control + R is a great shortcut that you can use in Microsoft Excel, and it allows you to copy the cell/range on the left of the selected cell and ...
Read more
This post first appeared on Excel If Statement Multiple Conditions Range, please read the originial post: here