1. put =A$1 in B1. (the $ makes the 1 absolute not relative, so it won't get changed by step 2) 2. grab the bottom right corner of cell B1 and drag down to B50.
1. put =A$1 in B1. (the $ makes the 1 absolute not relative, so it won't get changed by step 2)2. grab the bottom right corner of cell B1 and drag down to B50.