Excel set all column text to one value
Solution 1:
Enter "Male" in the first cell then select it and all the cells beneath it you want filled, then press Ctrl + D to fill down.
Enter "Male" in the first cell then select it and all the cells beneath it you want filled, then press Ctrl + D to fill down.