Someone asked me a question today and I have no idea what to answer. I showed them how to use the fill handle to auto fill the word Yes down a column. As the column was quite large and they are not that good at dragging with the mouse, they wanted to know if there was a way to fill cells E4:E40 with the word Yes without dragging the fill handle. Hope that makes sense. Any ideas would be appreciated.