Using QGIS, I want to fill a whole column with the same "word".

Is there a faster way or an expression I can use in the field calculator instead of copy/paste?

In some layers I have more than a thousand attributes.

  • 1
    Welcome to GIS SE! As a new user be sure to take the Tour to learn about our focussed Q&A format. What GIS software are you using? At least two of them have field calculators.
    – PolyGeo
    May 11, 2018 at 10:07
  • I'm using Q. I've been trying to google it but I've only seen videos where they copy paste. If only I could drag all the way down to fill the column or just use an expression, I don't know. May 11, 2018 at 10:15
  • 1
    "I'm using Q" means QGIS? QGIS 2.something or QGIS 3? I've added the tag for you. I'll make the title more descriptive too... Hang on...
    – Spacedman
    May 11, 2018 at 10:28
  • I'm using QGIS 2.18.15. Sorry I thought we weren't allowed to say software names May 11, 2018 at 10:32
  • 1
    Software names and versions are encouraged! What isn't liked is "How can I do A using X or Y or Z?", which could be three questions. Your Q is fine, the title was a bit vague so I've improved it.
    – Spacedman
    May 11, 2018 at 10:36

1 Answer 1


With a layer in edit mode and the attribute table opened, choose the field from the left-hand drop-down (it says "abc thi" here), set the value (in the box after the expression editor "E" sign), and hit "update all":

enter image description here

Note that string values have to be in single quotes ' in the expression box.

Switch edits off and save changes.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.