"Center Across Selection" only works across rows ... and cause problems if you mistype a value or miss one out. Excel's AutoFill can recognize patterns in your data and fill in the rest for ...