💻 Software
Excel set all column text to one value
Fresh5 days ago
Mar 15, 202654135 viewsConfidence Score0%
0%
Problem
I have a problem with Excel. I have added an extra column to my data, and I want to set all the rows of the column equal to the string "Male". Does anyone know how to achieve this?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Excel set all column text to one value
Low Risk
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.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix